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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can informatica load heterogeneous targets from heterogeneous sources?

697


what is $$$$?

1740


How can we use mapping variables in informatica?

599


What is the difference between STOP and ABORT options in Workflow Monitor?

699


Explain the mapping variable usage example in informatica

635






can u any challenge your project?

1610


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

1818


How to create or import flat file definition in to the warehouse designer?

618


What do you mean by worklet?

633


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

700


Define Pmrep command?

642


What is sq transformation?

668


What is dynamic cache?

614


How do you manage the Parameter files while migrating your data from one environment to another environment?

553


server hot-ws270 is connect to Repository B. What does it mean?

1857