i having source, router transformation, two targets in my
mapping... i given two conditions in router
1)sal >500
2)sal < 5000
---------------
my source is havig two sal records (1)1000 (2)2000
then which target will load first? will both targets are get
load or single target only get load...... why?
Answer Posted / sruthi
both targets get loaded.the first target gets loaded first and then the second.it cheks both the conditions,as both cannot be loaded in the same target,it loads the data even in the second target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
pmscmd startworkflow -sv
What is the difference between STOP and ABORT options in Workflow Monitor?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is mapping debugger?
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.
Differences between connected and unconnected lookup?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the sequence generator transformation in informatica?
What are the differences between oltp and olap?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What all join we can perform in LOOKUP transformation?
What is a dimensional model?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the scenario which compels informatica server to reject files?
can u give example for factless fact table