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

1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

waht is dataware house

2 Answers  

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 Answers  




What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

What is target designer and target load order?

0 Answers  

How the informatica server increases the session performance through partitioning the source?

1 Answers  

What is persistent lookup cache?

0 Answers  

How will u pas the data with out debugger?

4 Answers  

Explain the use of aggregator cache file?

0 Answers  

For more Informatica Interview Questions Click Here
Categories