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 target load order?

0 Answers  

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

what is the -ve test case in your project.

0 Answers   CTS, TCS,

What is sq transformation?

0 Answers  

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

Differentiate between mapping parameter and mapping variable?

1 Answers  

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

What is the format of informatica objects in a repository?

0 Answers  

What is enterprise data warehousing?

0 Answers