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
- 15591 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 |
What are the limitations of joiner transformation?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What are the tasks that source qualifier performs?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What is the way to execute pl/sql script using informatica mapping?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
What are the join types in joiner transformation?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Do you find any difficulty while working with flat files as source and target?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
Teradata 
