ETL Informatica Developer Interview Questions and Answers

Router is an active transformation as it can change the number of rows that pass through it based on conditions.

• Router transformation is used to route data from one source to multiple targets based on conditions.

• It can change the number of rows that pass through it based on the conditions specified.

• It evaluates each row against the conditions and sends the row to the appropriate output group.

• It is an active transformation as it changes the number of rows that pass through it....read more

Flat file target loading process

• Use Informatica PowerCenter to create a mapping

• Define the source and target connections

• Create a flat file target definition

• Map the source fields to target fields

• Configure the session properties

• Run the workflow to load data into the flat file target