Answer / sai.masarapu.chowdary

using normalizer transformation we can do as follows:

from source qualifier give the column to the normalizer tr
then put occur for 4 times.

put that occurs to the target. thats it..

Answer / jay

Just have four instance of target and
connect source to all 4 target instance.

Answer / jay

Hi Krish,

In the question it was mentioned clearly
that he "wants to insert 4 times (Duplicate)"

that means he does not have any unique constraint
in the target table.

If he wants to insert for 100 times daily?
Do you think is it easy to run the task for
100 times daily instead of create one mapping
as mentioned by me above and run it once daily?

Answer / krish

i really did'nt understand one thing if the target has PK on
it any of the methods specified above will not work.

let us think there is no PK on our T/G

the also all the methods above is wast of time

just run the secession 4 times

but the main thing (don't enable truncate the target table
option) .,.
if he say other than this option

then
Sai.masarapu.chowdary ans is good we can go with that.

Answer / anup shukla

Create router transformation with 4 different ports.
and set condition true for all the four ports.



and take it to the target from union trans.

Answer / kamleshmishra291

After sQ use a java transformation with this logic
for (int i=0;i<4;i++)
{
o_col= (input col that have the value);
generateRow();
}

Answer / paramaguru

source qualifier---field1
connect field1 to all the 4 field in the normalizer.
normalizer: In the normalizer maker occurs as 4
it will creat automatically
NEWfield1
NEWfield2
NEWfield3
NEWfield4
NEWFIELD
GK_NEWFIELD
GCID_NEWFIELD

target:OUTPUT
connect newfield to the target output

Answer / ch naveen kumar

let the attribute name be abcabc and name be aaa and table
name be 1

insert into 2 abcabc from 1 where count(aaa)<5;

Answer / prvn

can any one expalin it clearly

Answer / vinod kumar

copy the source for 3 times then total 4 sources will be
there in your mapping and move all sources to the target you
will get 4 times of same data in target

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

Difference Between ETL & ELT?

1 Answers   TCS,

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

can we override a native sql query within informatica? Where do we do it?

0 Answers  

How big was your fact table

0 Answers  

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

What all are steps in up gradation of Informatica server?

0 Answers  

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,