One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?
Answers were Sorted based on User's Feedback
Answer / usha
By using Sequence Generator transformation.
in Sequence Generator transformation we shoud set
start value =1
cycle should enable
end value = 3
increment value=1
in router we should give condion as
next value=1 for 1st group
next value=2 for 2nd group
next value=3 for 3rd group
S-->SQ--> seq-->rout--> Target1
Target2--> Target3
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / kns
source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cool buddy
take the rank T/R(take no.of ranks=4)and the take router t/r
in that give conditions as 1)rankindex=1,2)rkindx=2 etc.,
i think this will do .
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / sushma
Source ---> SQ ---> Expression ---> Router ---> Targets
Is This Answer Correct ? | 3 Yes | 4 No |
What is domain and gateway node?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
What is the status code?
What is dimensional table?
explain about informatica server architecture?
major difference between normal loading and bulk loading?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
How do you load alternate records into different tables through mapping flow?
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
what is the difference between Informatica7.1 & informatica 8.1