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

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1555


What are the tuning techniques you applied during your last project

1661


What are the guidelines to be followed while using union transformation?

742


lookup transformation with screenshots

3643


Which transformation should we use to normalise the COBOL and relational sources?

830






What are some examples of informatica etl programs?

622


What is olap (on-line analytical processing?

729


design of staging area?

1694


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

892


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

709


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

641


What is the function of look up transformation?

761


How do you load only null records into target? Explain through mapping flow.

1628


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1720


Briefly define a session task?

677