Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 15578 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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 workflow manager?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is an expression transformation?
What is a pre-defined event and user-defined event?
How can we improve session performance in aggregator transformation?
How to open an older version of an object in the workspace?
In development project what is the process to follow for an etl developer from day1
Differentiate between Load Manager and DTM?
How might one distinguish in the case of mapping is right or not without associating session?
What is sequence generator transformation in informatica?
How can you define user defied event?
What are the advantages of informatica?
Informatica settings are available in which file?
can anyone explain me about retail domain project in informatica?
What is the benefit of session partitioning?
