Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravi awasthi
Router
1. Router transformation divides the incoming records into multiple groups based on some condition. Such groups can be mutually inclusive (Different groups may contain same record)
2. Router transformation itself does not block any record. If a certain record does not match any of the routing conditions, the record is routed to default group.
3. Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C)
Filter
1. Filter transformation restricts or blocks the incoming record set based on one given condition.
2. Filter transformation does not have a default group. If one record does not match filter condition, the record is blocked.
3. Filter acts like WHERE condition is SQL.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What does command task mean?
Which version configuration tool used in ur project?
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
Describe data concatenation?
Clarify the aggregator change?
Plz can any one say me how to get the informatica certification materials and dumps
What is the benefit of session partitioning?
What is DR strategy for Informatica project?
What is dimensional table?
What are mapplets? How is it different from a Reusable Transformation?
Explain load alternative records / rows into multiple targets - informatica
How is union transformation utilized?
What is the use of an aggregator cache file?
How can we use mapping variables in informatica? Where do we use them?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
