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

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..

5 Answers   iGate,

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

What is a code page?

0 Answers  

Types of error logs in Informatica?

2 Answers  

COM components can be used in Informatica

0 Answers  




If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

what are testing in a mapping level please give brif eplanation

1 Answers   CTS,

What is pmcmd command?

0 Answers  

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

What does command task mean?

0 Answers  

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories