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

Just have four instance of target and
connect source to all 4 target instance.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the cumulative sum and moving sum?

752


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1769


What is a snowflake schema?

565


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1075


Differentiate between reusable transformation and mapplet.

568






Explain the mapping variable usage example in informatica

629


What are the types of caches in lookup? Explain them.

547


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1533


What are the differences between joiner transformation and source qualifier transformation?

620


How many ways a relational source definition can be updated and what are they?

574


What is the difference between STOP and ABORT options in Workflow Monitor?

691


Which transformation is needed while using the Cobol sources as source definitions?

723


What does refresh system mean, and what are its distinctive choice?

564


Explain about cumulative Sum or moving sum?

618


What is the reusable transformation?

621