Answer / suresh

Given
sal>500
sal<5000
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.

Answer / moorthy g

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

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.

Answer / manojkumar

Hi Everybody,
Please check question again.
It is

" which target will load first? "

and

"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
next.
I am not sure about it. I am also searching answer for this
question.

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
target.

Thanks.
James

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.

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

Answer / chandana

Use Target load order to specify which one to be loaded
first.

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
condition....

what is upstream and downstream transformation?

7 Answers  

What is repository manager?

0 Answers  

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

What are conformed dimensions?

1 Answers  

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

What is parameter file?

2 Answers  

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

how to load rows into fact table in data warehouse

0 Answers   Informatica,

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,