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 / 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? "
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.
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
target.
Thanks.
James
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
first.
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
condition....
Is This Answer Correct ? | 2 Yes | 22 No |
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
What is the difference b/w natural key and surrogate key
Explain the features of connected and unconnected lookup.
How to eliminate duplicates from flat file..what is the procedure
what is the Default Source Option For Update Strategy Transformation?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
What is the function of look up transformation?
What are the tasks that source qualifier perform?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?