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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

define galaxy repository in informatica

1729


How can one identify whether mapping is correct or not without connecting session?

883


What are mapplets?

826


What is a filter transformation and why it is an active one?

564


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

700






How can informatica be used for an organization?

653


What is joiner change?

683


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1561


What is the need of etl tools?

613


What are the steps involved in the migration from older version to newer version of Informatica Server?

1585


What does update strategy mean, and what are the different option of it?

590


Explain pmcmd command usage in informatica

708


Repository user profiles

1377


What is the status code in stored procedure transformation?

687


How might you approve all mappings in the archive all the while?

602