One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd ta

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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?

Question Posted / sunil.knl

5 Answers
13188 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist t..

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

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist t..

Answer / sanjay

Sq-->Expression-->Router-->Target
| |
| v
v grp1--> col=1
mod(col,3) grp2--> col=2
Default

Is This Answer Correct ?

3 Yes

0 No

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist t..

Answer / kns

source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets

Is This Answer Correct ?

0 Yes

0 No

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist t..

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

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist t..

Answer / sushma

Source ---> SQ ---> Expression ---> Router ---> Targets

Is This Answer Correct ?

3 Yes

4 No

Post New Answer