Use Target load order to specify which one to be loaded first.

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?

Question Posted / chandana

9 Answers
21114 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / chandana

Use Target load order to specify which one to be loaded
first.

Is This Answer Correct ?

3 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between a gateway node and worker node?

1061

What is meant by incremental aggregation?

1016

How can we remove the duplicates from flat file source?

947

Briefly describe lookup transformation?

982

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1196

What is complex mapping?

1060

What is update strategy transform?

1009

What is the difference between informatica 7.0 and 8.0?

951

Explain informatica architecture - version 8 / 9

1018

What is substr in informatica?

1131

How do you load only null records into target? Explain through mapping flow.

1955

What is Data Caches size?

1029

Can we create two repositories on same database instance in oracle?

1011

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

996

What is a router transformation?

1044