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..

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

What are the rank caches?

2 Answers   Informatica,

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

What is a unit Testing?

1 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

What is the use of incremental aggregation?

2 Answers  

how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  

What are different types of transformations available in informatica?

0 Answers