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

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

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 is SDLC way of code development?

0 Answers  

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

what is index?how it can work in informatica

0 Answers  

how many types of dimensions are available in informatica?

0 Answers  

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

why dimenstion tables are denormalized in nature ?

3 Answers