Answer Posted / srinivas
1.Filter will removes unwanted data based on a filter
condition,if we want use multiple filter conditions using
filter it is not possible,so we have another option i.e router.
2.Router:advantage is one input can be passed and based
on filter conditions output will be get,here matched
condition and un-matched condition records can be get
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
How can we update a record in the target table without using update strategy?
What do you understand by a term domain?
Explain what are the different types of transformation available in informatica.
Can we override a native sql query within informatica?
What is repository manager?
Have you worked with/created Parameter file
Explain pmcmd command usage in informatica
Can we create a node as a gateway node and the same node can be assigned to a grid?
Quickly characterize reusable change?
explain abt ur project architecture?
Explain transaction control transformation in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
