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

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

688


Define filter transformation?

601


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

635


What are the different types of transformation available in informatica.

610


What is the difference between informatica 7.0 and 8.0?

548






What is a joiner transformation?

525


Explain in detail about scd type 1 through mapping.

554


write a query to retrieve the latest records from the table sorted by version(scd)

615


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

535


explain about unit testing? in real time?

1631


What is the format of informatica objects in a repository?

579


What is lookup transformation?

564


In informatics server which files are created during the session rums?

608


How can we store previous session logs?

544


Enlist the tasks for which source qualifier transformation is used.

564