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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you use flat files in Mapplets.

2312


Enlist few areas or real-time situations where informatica is required.

691


Differentiate between source qualifier and filter transformation?

1118


Which means the first record should come as last record and last record should come as first record and load into the target file?

696


What are the transformations that are not supported in mapplet?

682






What are the components of the workflow manager?

749


Explain sessions and how many types of sessions are there?

676


r u done any partitions in ur project?

1475


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

759


What is the use of an aggregator cache file?

778


What do mean by local and global repository?

813


What is domain in terms of informatica?

644


How to load the data from a flat file into the target where the source flat file name changes daily?

662


How does the aggregator transformation handle null values?

801


What are the types of caches in lookup?

667