if soource is having 10 records how will u insert 20
records to target
Answer Posted / sanjay
keep the "Truncate Target Table Option" uncheck in the
session and run the workflow two times..
You can get the 20 records..
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
How many ways are there to do 'remove duplicate records in informatica'?
Explain about cumulative Sum or moving sum?
Tell me about Propagate functions in informatica
waht type of interface is used for testing the data in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the different types of transformation available in informatica.
how to create user defined function (udf) in informatica
What is a rank transform?
How can a transformation be made reusable?
What is aggregate cache in aggregator transformation?
How can we store previous session logs?
Difference between Target-based loading and constraint-based loading?
Please let me know how to make Data masking in informatica..
What differs when we choose the sorted input for aggregator transformation?