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
Mention few power centre client applications with their basic purpose?
What does refresh system mean, and what are its distinctive choice?
What are ETL Tools?
How to generate sequence numbers?
How do you take back up of repository?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is the -ve test case in your project.
Whats there in global repository
What are the static cache and dynamic cache in informatica?
Separate from an archive server and a powerhouse?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is fact table? Explain the different kinds of facts.
What are the types of lookup transformation?
have u done any performance tuning? how u ll do?
generate date / time dimension in informatica