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
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is meant by lookup transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the guidelines to be followed while using union transformation?
scenario where i can use only concurrent execution of workflow.
Which files are created during the session rums by informatics server?
What do you mean by enterprise data warehousing?
How does a rank transform differ from aggregator transform functions max and min?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is rank transformation in informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the different lookup cache(s)?
What is the sequence generator transformation in informatica?
What is exclusive and normal mode for repository services?