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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

598


What are the conditions needed to improve the performance of informatica aggregator transformation?

584


Is it possible to create multiple domains on a single Informatica server?

755


can we override a native sql query within informatica? Where do we do it?

626


What is a router transformation?

628






What is meant by incremental aggregation?

585


Where do we use mapping variables in informatica?

617


Mention few power centre client applications with their basic purpose?

538


write a query to retrieve the latest records from the table sorted by version(scd)

632


What is decode in informatica?

656


What is data transformation manager process?

619


How to load data in informatica ?

574


Clarify the aggregator change?

595


How to use procedural logic inside infromatica?

636


How would you copy the content of one repository to another repository?

557