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
What are the designer tools for creating transformations?
What is the meaning of decode in informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is a passive transformation?
What are active transformations.
What do mean by local and global repository?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Define the various join types of joiner transformation?
Briefly describe lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
What are the settings that you use to configure the joiner transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
how tokens will generate?
I have a flat file, want to reverse the contents of the flat file
What is a code page?