1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sanju_yu

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

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,

how we do performence tuning in informatica

3 Answers  

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

What is source qualifier transformation?

1 Answers  

how tokens will generate?

0 Answers  




What are the out put files that the informatica server creates during the session running?

2 Answers  

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,

without table how to come first record only in oracle?

0 Answers  

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

What is an expression transformation?

0 Answers  

need for registering a repository server

1 Answers  

For more Informatica Interview Questions Click Here
Categories