Informatica – PowerCenter – Active transformations

Functionality: Change the number of rows Change the transaction boundary Change the row type Rules : Doesn’t allow to connect multiple active transformations/an active and passive to the same downstream transformation/transformation input group.because the integration service may not be able to concatenate the rows passed by active transformation. Sequence generator is exceptional to this rule […]

powercenter SQL Trans Query Mode :Multiple SQL statements Issue

Problem Definition: In Informatica Powercenter 9.0.1(can be applicable to other versions)we want to create multiple dynamic SQL statements with SQL transformation in Query mode,then we have encountered following error: ORA-00911 : Invalid Character Database Driver error Input Data :’insert into TEST_TABLE values(1) ; insert into TEST_TABLE values(2) ; insert into TEST_TABLE values(3);’  Solution: Modify your SQL with […]