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 / 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();
}

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does “tail –f” command do and what is its use as an Informatica admin.

633


Explain sessions. Explain how batches are used to combine executions?

597


Which version configuration tool used in ur project?

2770


How to configure mapping in informatica?

676


what is the size of your data warehousing?

1673






Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

609


What are the types of presistent cache in look up tr.

1551


What do you mean by enterprise data warehousing?

646


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

628


How do you load only null records into target?

742


How to create a non-reusable instance of reusable transformations?

685


What can we do to improve the performance of informatica aggregator transformation?

620


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

740


What is the format of informatica objects in a repository?

603


What does reusable transformation mean?

676