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

Given
sal>500
sal<5000
sal 1(1000)
sal 2(5000)
By using router transformation both targets are get loaded,because here two sal are greaterthan 500 and lessthan 5000.

Is This Answer Correct ?    16 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can create indexes after completing the load process?

789


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1780


What are the new features of informatica 9.x in developer level?

645


what is diff b/t sorter t/r and agg have the option sorter property...

1853


How do you handle two sessions in Informatica

768






explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1793


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2068


How would you copy the content of one repository to another repository?

651


What is a filter transformation?

672


Why filter transformation is an active one?

670


Global and Local shortcuts. Advantages.

1566


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

700


Write the advantages of partitioning a session?

853


what are the deliverables?in your project?

1769


State the limitations where we cannot use joiner in the mapping pipeline?

636