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

Why is sorter an active transformation?

637


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

635


can we override a native sql query within informatica? Where do we do it? How do we do it?

579


How can you differentiate between powercenter and power map?

604


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

3213






What is data caches/ index caches?

591


Can we change Dynamic to Static or Persistent cache? If so what happens?

1694


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1490


What do you mean by worklet?

602


Define sessions in informatica etl?

601


Reusable transformation and shortcut differences

1350


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

1715


How will the document be delivered to me?

594


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

615


What is domain and gateway node?

668