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

Explain how many types of dimensions are available in informatica?

595


Define enterprise data warehousing?

636


What is parallel processing in informatica?

1031


what is the difference between informatica6.1 and infomatica7.1

1719


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1503






What is the difference between stop and abort in informatica

666


What is fact table? Explain the different kinds of facts.

616


What does cheating measurement mean?

600


While migrating the data from one environment to another environment how would you manage the connections?

627


whats the logic to load the lower level of granularity of data to fact table.

1805


How we can create indexes after completing the load process?

615


How many numbers of sessions can one group in batches?

623


What is meant by active and passive transformation?

587


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

636


What is target load order?

807