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
- 15337 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 |
How to update a particular record in target with out running whole workflow?
Explain load alternative records / rows into multiple targets - informatica
What is the commit type if you have a transaction control transformation in the mapping?
any body can say about all versions of informatica ?how many versions ?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
what is the diff b/w cached and unchaed look ups
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Flat file heaving 1 lack records and I want to push 52000 records to the target?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Teradata 
