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
Tell me about MD5 functions in informatica
What is informatica etl tool?
Describe expression transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you load unique records into one target table and duplicate records into a different target table?
what are the Methods For Creating Reusable Transformations?
How to create a non-reusable instance of reusable transformations?
Explain pushdown optimization $pushdownconfig parameter - informatica
Clarify the utilization of aggregator cache record?
What is target designer and target load order?
How do you set a varible in incremental aggregation
Explain what are the different versions of informatica?
Which is the t/r that builts only single cache memory?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
