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
- 15338 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
How do you migrate data from one environment to another?
How many number of sessions can one group in batches?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Name the different lookup cache(s)?
How do you update the records with or without using update strategy?
What are the differences between joiner transformation and source qualifier transformation?
What are the components of Informatica? And what is the purpose of each?
How to elaborate tracing level?
Describe expression transformation?
Scheduling properties,whats the default (sequential)
how tokens will generate?
Separate from an archive server and a powerhouse?
What happens when a session fails and you click on recover?
Explain the shared cache and re-cache?
Explain the difference between mapping parameter and mapping variable?
