Informatica - Difference between router and filter transformation

Question

Accepted Answer

Router and filter transformations are used in Informatica for data filtering, but they have different functionalities.

Router transformation is used to route data based on specified conditions to multiple output groups.
Filter transformation is used to filter rows based on specified conditions and pass only the matching rows to the output.
Router transformation can have multiple output groups, each with its own condition.
Filter transformation has a single output group.
Router transformation can be used to implement complex data routing logic.
Filter transformation is used for simple row filtering based on conditions.

Accepted Answer

information tecnology

Accepted Answer

router transformation is single input and multi output transformation.

filter transformation izs only one filter condition

Top AT&T Technical Specialist (Data Warehousing) interview questions & answers