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


Please Help Members By Posting Answers For Below Questions

What is the advantage of informatica?

819


Does an informatica transformation support only aggregate expressions?

795


What is workflow manager?

772


What is the difference between stop and abort in informatica

862


In informatics server which files are created during the session rums?

844


What do mean by local and global repository?

911


What is exclusive and normal mode for repository services?

885


How do you load first and last records into target table?

910


Have you worked with/created Parameter file

1398


What is the difference between informatica 7.0 and 8.0?

739


What are ETL Tools?

843


What are the tasks that source qualifier perform?

818


What is meant by incremental aggregation?

750


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

838


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1354