Hi,
In Informatica Power Center What the difference between Data Transformation configured to use dynamic service name or static service name ? What are the uses of both options?
DT services can be invoked dynamically according to a context defined at run time. Let’s take an example, where there are 2 XLS documents of different format, that needs to be extracted into a one canonical XML. In this case, rather than creating 2 separate PWC mappings each dealing with different format, you can implement only one mapping . in the mapping according to the xls format, you can invoke the right DT service name, by using the Dynamic UDT service name. The Static DT is simpler, you just need choose the DT name in UDT module. In this case same DT would be executed wach time the pwc mapping runs.
