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
What are the types of presistent cache in look up tr.
how we can load rejected record's at run time?(not through bad files)
How do you convert single row from source into three rows into target?
can anyone explain me about retail domain project in informatica?
What are active transformations.
On which transformations you created partitions in your project?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are active and passive transformations?
What is intricate mapping?
What is the sql query overwrite in source qualifier in informatica
What is native users?
Why sorter is an active transformation?
What do you mean by channel change?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the pipeline partition with real time example?