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 / chandana
Use Target load order to specify which one to be loaded
first.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Why do we need informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to update a particular record in target with out running whole workflow?
Can we get 1st record through Informatica(without sequence number).
What is difference between a gateway node and worker node?
Why is sorter an active transformation?
Briefly define reusable transformation?
what is Active lock explain
What is workflow? What are the components of the workflow manager?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is mapping debugger?
Which transformation is needed while using the Cobol sources as source definitions?
What is exclusive and normal mode for repository services?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between router and filter?