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
- 15346 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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the different types of repositories created using informatica?
What does role playing dimension mean?
What is a sequence generator transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the maplet?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Enlist the differences between database and data warehouse.
What is DR strategy for Informatica project?
How can repository reports be accessed without sql or other transformations?
What are the transformations that are not supported in mapplet?
What is the function of look up transformation?
Performance tuning( what you did in performance tuning)
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are data-driven sessions?
