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?
- 9 Answers
- 18978 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / jvdwhinfo
Hi Guys,
Both the targets are loaded with both the records as both
condition are satisfied.
And the order of loading is, first target 1 is loaded and
next target 2 is loaded as informatica loads target by
target.
Thanks.
James
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
What is the format of informatica objects in a repository?
How to join three sources using joiner? Explain though mapping flow.
Why update strategy and union transformations are active? Explain with examples.
Explain transaction control transformation in informatica
What is Session and Batches?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the transformations that are not supported in mapplet?
What is complex mapping?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
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 ?
To import the flat file definition into the designer where should the flat file be placed?
Explain the different kinds of facts.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
