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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the function of aggregator transformation?
What does cheating measurement mean?
Define Pmrep command?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the difference between a data warehouse and a data mart?
What do you mean by filter transformation?
Explain sql transformation in script mode examples in informatica
Which development components of informatica have the highest usage?
What is sq transformation?
Explain the different lookup methods used in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What does update strategy mean, and what are the different option of it?
Explain what are the different versions of informatica?