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

What is the advantage of informatica?

0 Answers  

Insert else update option in which situation we will use

4 Answers   HCL,

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

When the informatica server marks that a batch is failed?

1 Answers  

what is the size of u r source(like file or table)?

0 Answers   HP,

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

how to connect two or more table with single source qualifier?

4 Answers   IBM,

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers