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

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

How do you recover rows from a failed session

1 Answers  

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

4 Answers   TCS,

When to use normalization transformation other than cobol source?

2 Answers  

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,