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
- 15803 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / manu
Hi IBM,
I have a solution for this.
1) From source qualifier get the records to the Expression.
2) Use one Sequence generator in which set the max value as
3 , enable cycle option. Connect it to the expression.
3) then use router & create 2 groups, 1st group condition
as Next value = 1 another as next value = 2 and default.
4) These should be connected to the 3 target tables.
The requirement will be achieved.
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
can we override a native sql query within informatica? Where do we do it?
What are some examples of informatica etl programs?
What are the popular informatica products?
Explain the tuning lookup transformation - informatica
Differentiate between sessions and batches?
What do you understand by SOA of Informatica?
What do you mean by worklet?
What is meant by pre and post session shell command?
4 yrs etl devloper roles and responsibilities?any body give solutions
What are batches?
What is confirmed fact in dataware housing?
what is the -ve test case in your project.
What is data caches/ index caches?
What are the tuning techniques you applied during your last project
