Given sal>500 sal<5000 sal 1(1000) sal 2(5000)

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

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

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

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2062

In informatica workflow manager, how many repositories can be created?

1272

Explain incremental aggregation in informatica

1069

Explain joiner transformation in informatica

1077

How to do unit testing in informatica?

1125

Explain what transformation and how many are there in informatica?

891

What's the layout of parameter file (what does a parameter file contain?)?

2337

What are the transformations that are not supported in mapplet?

959

What is the function of union transformation?

1067

design of staging area?

1966

What do you mean by enterprise data warehousing?

1003

What is the Rank index port in Rank transformation?

1015

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2058

Define pmcmd command?

994

How many input parameters can exist in an unconnected lookup?

1493