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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

597


Explain the scenario which compels informatica server to reject files?

657


scenario where i can use only concurrent execution of workflow.

2546


Explain what are the different types of transformation available in informatica.

574


Mention some types of transformation?

607






what are 3 tech challenges/ common issues you face?

1891


my source is junk data how will u remove that junk data by using unix please any one replay me

3243


what is $$$$?

1738


Have you worked with/created Parameter file

1226


difference between repository database and repository service?

624


Explain dynamic target flat file name generation in informatica

650


Briefly describe lookup transformation?

600


What is source qualifier transformation in informatica?

575


How to go to the older version for a mapping?

604


Explain constraint based loading in informatica

659