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?
- 5 Answers
- 11076 Views
- HCL, I also Faced
- E-Mail Answers
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 pmcmd command?
difference between stop and abort
What is workflow? What are the components of workflow manager?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Quickly characterize reusable change?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
What you know about transaction control transformation?
What is a difference between complete, stop and abort?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How many transformations can be used in mapplets.
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Teradata 
