Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
Answers were Sorted based on User's Feedback
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..
Is This Answer Correct ? | 18 Yes | 0 No |
Answer / jay
Just have four instance of target and
connect source to all 4 target instance.
Is This Answer Correct ? | 10 Yes | 1 No |
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?
Is This Answer Correct ? | 5 Yes | 0 No |
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.
Is This Answer Correct ? | 6 Yes | 2 No |
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.
Is This Answer Correct ? | 2 Yes | 0 No |
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();
}
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
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;
Is This Answer Correct ? | 2 Yes | 2 No |
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
Is This Answer Correct ? | 1 Yes | 8 No |
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
waht is dataware house
Can we use the mapping parameters or variables created in one mapping into another mapping?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
What is IQD file?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
What are the join types in joiner transformation?
If I am having 6 flat files in data. How can you load the data at a time
What is difference between maplet and reusable transformation?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
What is the status code in stored procedure transformation?
When do you use mapping parameters? (In which transformations)