What is the difference between a router and a filter
transformation?
Answer Posted / sbvp
router filter
1.mutlipule conditions here 1.single condition here
2.send to multiple targets 2.single target
3.it captures the rejected records 3.it doesnot capture
in default output rejected records
group.
4.this is active t/r 4. this is also activet/r
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is joiner change?
What does “tail –f” command do and what is its use as an Informatica admin.
How do you load only null records into target? Explain through mapping flow.
According to his methodology what all you need before you build a datawarehouse
What is Cognos script editor?
What are the types of lookup transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between a repository server and a powerhouse?
Define Pmrep command?
What is informatica?
What do you mean by channel change?