I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
Answer Posted / srinivas
I had another simple solution ...
1.use router transforamation .. generate 3 groups and use
sequence generator ... next value connnct to router
transformation... and logic is
mod(next,3)=1,mod(next,3)=2,mod(next,3)=0,,
connct to 3 targets load it...
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What is an unconnected transformation?
Tell me about MD5 functions in informatica
what is INFORMATICA TESTING process
What do think which one is the better joiner or look up?
What is aggregate cache in aggregator transformation?
Reusable transformation and shortcut differences
What is the different lookup cache(s)?
which one is better performance wise joiner or look up
What is mapping debugger?
Explain in detail scd type 2 through mapping.
tell me the rules and responsblites in our project(my project is development)
What is an expression transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Please let me know how to make encryption and decryption with example?