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

What is a router transformation?

0 Answers  

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

Explain what are the different versions of informatica?

0 Answers  

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

What is lookup change?

0 Answers  

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

Why union transformation is an active transformation?

0 Answers   Informatica,

What is primary and backup node?

0 Answers