Answer Posted / justin
Filter transformation is used to filter out unwanted records that does not satisfy its condition
Router Transformation provide you the flexibility of populating multiple target depending upon the different type of conditions
I was able to find a good article on it at
http://www.tecktricks.com/difference-between-filter-transformation-and-router-transformation-in-informatica/
Hope it will help you :)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
Enlist the advantages of informatica.
Is there any target staging area in informatica not staging area
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a repository? And how to add it in an informatica client?
What is meant by incremental aggregation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain sessions. Explain how batches are used to combine executions?
what is informatica metadata?
What are connected or unconnected transformations?
Explain pushdown optimization and types in informatica
What is the sequence generator transformation in informatica?