I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
Answers were Sorted based on User's Feedback
Answer / susanta
Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.
after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.
Hope this will help u
Is This Answer Correct ? | 28 Yes | 1 No |
Answer / ks316
Hi all,
I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.
I think there should be a condition to every group in the
router.
i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,
pls correct me if i am wrong
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / avatar dss42b88
for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure
sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.
Is This Answer Correct ? | 3 Yes | 3 No |
Differentiate between sessions and batches?
Which transformation should u need while using the cobol sources as source defintions?
Is there any target staging area in informatica not staging area
How are parameters defined in informatica?
What is complex mapping?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
generate date / time dimension in informatica
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
Explain the different dimensions.
how to join the 2 different table with different columns in informatica?
How many cubes create from a single model?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000