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 |
What happens if we dont select data driven option?
What are the types of caches in lookup?
What is the need of etl tools?
what is shortcut in informatica? difference between shortcut,reusable object?
how we do performence tuning in informatica
8.what is mapplet ?give example?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
What is the different lookup cache(s)?
Without source how to insert record to target?
what is normalizer transformation?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What r the type of indexes u generally used in informatica?