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



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

More Informatica Interview Questions

what is lookup chache?

1 Answers   Patni,


What is a taget load order?

2 Answers   IBM,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


What is informatica? Why do we need it?

0 Answers  


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,






In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,


What is aggregate cache in aggregator transformation?

0 Answers   Informatica,


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


What is the need of an ETL tool?

0 Answers   Informatica,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,


Categories