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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository? And how to add it in an informatica client?

773


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8929


How to delete duplicate row using informatica?

697


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

662


What is an expression transformation?

704






Separate from a database, an information bazaar, and an information stockroom?

702


what is song in infrmatica...?

1812


Slowly changing dimensions, types and where will you use them

1364


What are the components of the workflow manager?

749


What are the mapping parameters and mapping variables?

716


What does cheating measurement mean?

684


In how many ways we can create ports?

799


How would you join a node to the already existing domain?

795


Mention a few design and development best practices for informatica?

657


What is the difference between informatics 7x and 8x and what is latest version?

651