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?

Answers were Sorted based on User's Feedback

Answer / suresh

sal 1(1000)
sal 2(5000)
By using router transformation both targets are get loaded,because here two sal are greaterthan 500 and lessthan 5000.

Is This Answer Correct ?    14 Yes 2 No

Answer / moorthy g

Both Condition Are Satisfied,
So, It will load two targets. (T1 And T2)

Is This Answer Correct ?    10 Yes 1 No

Answer / jayashree

Refer to Page 302 of Transformation Guide:
If a row meets more than one Group Filter Condition, then PC
Server passes this row multiple times.
Hence both the targets will be loaded

PC Server determines the order of evaluation for each
condition based on the order of connected output groups.
Hence first Target1 and then Target 2.

Is This Answer Correct ?    6 Yes 0 No

Answer / manojkumar

Hi Everybody,
Please check question again.
It is

" which target will load first? "


"will both targets are get
load or single target only get load...... why"

As per my knowledge,
It will load into two targets defenetly. There is no doubt
about it. And It will load same time into two targets or
first target will be first and second group target will be
I am not sure about it. I am also searching answer for this

Is This Answer Correct ?    4 Yes 1 No

Answer / 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


Is This Answer Correct ?    1 Yes 0 No

Answer / 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

Answer / sameer

according to router group condition first load data the into target sal<500 and then load the data into the target sal<5000 because the informatica server check the group condtion according to router group then load then the data into the target means in target t1 1000 and then load taeget t2 5000

Is This Answer Correct ?    0 Yes 0 No

Answer / chandana

Use Target load order to specify which one to be loaded

Is This Answer Correct ?    3 Yes 6 No

Answer / jani basha

both records are load into 1st target only.... because in
Router if 1st condition satisfies then it will not go to 2nd

Is This Answer Correct ?    2 Yes 21 No

Post New Answer

More Informatica Interview Questions

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,


7 Answers   Target,

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Deloitte, Amdocs,

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, iGate, IBM,

What is joiner cache?

2 Answers   TCS,

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

What are the connected or unconnected transforamations?

2 Answers  

replace multiple spaces with single space.

3 Answers   IBM,

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,