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

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

What is sorter transformation?

0 Answers  

What is staging area?

11 Answers  

Have you worked with/created Parameter file

0 Answers  

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

What is the session task and command task?

0 Answers  

In session log thier should not be a single error how will u do

3 Answers   HCL,

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

What is a predefined event?

0 Answers  

what is mapping parameter?

2 Answers   Cap Gemini,