Benefit of UDT dynamic service in power Center

DWQA QuestionsBenefit of UDT dynamic service in power Center
A.B Link Consulting Team Staff asked 10 years ago

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?

1 Answers
A.B Link Consulting Team Staff answered 10 years ago

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.