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

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,

What is update strategy transform?

0 Answers  

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

what is the dashbords?

1 Answers   IBM,

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

What is informatica etl tool?

0 Answers  

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

What could be the possible resons of locks by user?

0 Answers  

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

What is confirmed dimension?

3 Answers