I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Answer Posted / kamleshmishra291
what i understand is when first time run source have two records and it got inserted in target and then source data was deleted and new 10 records were inserted . In this case when you run wf again it will insert 10 records to target then , totally we will have 12 records in target
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can u any challenge your project?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a joiner transformation?
define galaxy repository in informatica
How to delete duplicate row using informatica?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are session parameters ? How do you set them?
what are the Methods For Creating Reusable Transformations?
Explain about cumulative Sum or moving sum?
r u done any partitions in ur project?
What are the tuning techniques you applied during your last project
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain sessions and how many types of sessions are there?
Differentiate between sessions and batches?
How would you copy the content of one repository to another repository?