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 is informatica metadata?
What are the different options available for update strategy?
Why do you use Mapping Parameter and mapping variable?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
tell me about your project functionality
What is the difference between Active and Passive transformation?
what is index?how it can work in informatica
How can you increase the performance in joiner transformation?
EXL informatica Questions
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Sequence generator, when you move from develoment to production how will you reset
Can u generate reports in Informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the use of code page?