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

Answers were Sorted based on User's Feedback

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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.

 Is This Answer Correct ? 14 Yes 2 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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

 Is This Answer Correct ? 10 Yes 1 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Hi Everybody,
It is

" which target will load first? "

and

"will both targets are get

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.

 Is This Answer Correct ? 4 Yes 1 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

Hi Guys,

Both the targets are loaded with both the records as both
condition are satisfied.
target.

Thanks.
James

 Is This Answer Correct ? 1 Yes 0 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

first.

 Is This Answer Correct ? 3 Yes 6 No

i having source, router transformation, two targets in my mapping... i given two conditions in rou..

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

 Is This Answer Correct ? 2 Yes 21 No

how to delete duplicate records by using filter transfermation?

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

What is the difference between bitmap and btree index?

Why we select the table which has minimum number of records as Master table in joiner?

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

What is A cache?

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

any body can say about all versions of informatica ?how many versions ?

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

what is mapping optimization? wat are the techniques for tat

what are the deliverables?in your project?

Categories