Answer / suresh

Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router

Answer / gangadhar

Hi suresh you are 50% current

sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3

drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes

later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3

first group connect to T1
second group connect to t2
third group connect to t3

is 100% correct

Answer / rakesh

use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0

Im not sure about MOD format, but this idea will workout..

Answer / uppala chary

suresh answer is correct

Answer / venkat

->Connect desired columns to Expression and create custom
colum.
->Use Sequence Gen inorder to generate cyclic values 1,2,3
logic :start with 1 ,increment by 1 and end with 3
Cycle -Yes.
->Connect it to Custom column
->Use Router to rout coresponding group
Group1 -Value1- Target1
Group2 -Value2- Target2
Default-Value3- Target3

Answer / triveni

startvalue=1
endvalue=3
cycle=yes seequencegenerator
\
source->sq->expression->router->target1
->target2
expression->copy nextval port to expression
router->mod(seq,3)=1
mod(seq,3)=2
mod(seq,3)=0

Answer / omkar

use router transformation
in that give condition 1st row id to 1st target
and so..

Explain lookup transformation in informatica

0 Answers   Informatica,

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

how to remove staging area

1 Answers  

how to move the mappings from your local machine to claint place?

2 Answers  

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

What is a configuration management?

1 Answers  

How many transformations can be used in mapplets.

0 Answers  

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

what is fact table?

9 Answers  

What are the different tools in workflow manager?

1 Answers  

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers