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?
Answer Posted / 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 |
Post New Answer View All Answers
How can we remove the duplicates from flat file source?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the difference between Active and Passive transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Make a note of the quantity vaults made in informatica?
What is a snowflake schema?
How can we create index after completion of load process?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is the reusable transformation?
Explain the use of aggregator cache file?
How union transformation is used?
Explain sessions and how many types of sessions are there?
Which is the t/r that builts only single cache memory?
Can we get 1st record through Informatica(without sequence number).
What is the status code in stored procedure transformation?