Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

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

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

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

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

Answer / manu

Hi Srinivas,

Even I gave the same solution. Can you please check.

Is This Answer Correct ?    5 Yes 4 No

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

Answer / sajju

@MANU
@srinvas

Both are correct

Is This Answer Correct ?    0 Yes 0 No

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

Answer / im

Using Constraint Based Loading option in SQ T/r......

Is This Answer Correct ?    0 Yes 2 No

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records..

Answer / jayesh

Use target load plan.
Option is available in mappping designer.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer



More Informatica Interview Questions

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,


What are the joiner caches?

3 Answers   Informatica,


what is the predefined port in dynamic lookup

2 Answers  


case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  


we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  






To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

0 Answers   Informatica,


EXL informatica Questions

0 Answers  


What are pre and post-session shell commands?

0 Answers  


What is the procedure to load the fact table.Give in detail?

1 Answers  


i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,


What is a command that used to run a batch?

2 Answers  


There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,






Categories