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
- 15510 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / manu
Hi Srinivas,
Even I gave the same solution. Can you please check.
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / im
Using Constraint Based Loading option in SQ T/r......
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / jayesh
Use target load plan.
Option is available in mappping designer.
| Is This Answer Correct ? | 0 Yes | 5 No |
I have source like this 1:2;3. so i want to load the target as 123
Difference between session variables and workflow variables?
Explain sql transformation in script mode examples in informatica
Can we override a native sql query within informatica?
What are the tasks that source qualifier perform?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
why we use source qualifier transformation?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
how to run 2 workflows sequentially. plz respond what is the process?
What are the basic needs to join two sources in a source qualifier?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Teradata 
