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
- 15573 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
Which files are created during the session rums by informatics server?
What is Index Caches size?
Define Pmrep command?
How many ways are there to do 'remove duplicate records in informatica'?
What the difference is between a database, a data warehouse and a data mart?
What is the difference between a connected look up and unconnected lookup?
Can we create two repositories on same database instance in oracle?
Under what condition selecting sorted input in aggregator may fail the session?
How can we remove the duplicates from flat file source?
Explain lookup transformation source types in informatica
What are the modules in Power Center
What are the types of schemas we have in data warehouse.
What are the new features of informatica 9.x at the developer level?
Differentiate between sessions and batches?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
