Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11369 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / naveen
This option we use when we want to maintain the history.
if records are not availabe in target table then it inserts
the records in to target and records are available in
target table then it updates the records.
Regards,
Naveen
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we improve session performance in aggregator transformation?
Explain the features of connected and unconnected lookup.
What is the cumulative sum and moving sum?
Write the unconnected lookup syntax and how to return more than one column.
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the different transaction levels available in transaction control transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the advantages of informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is dimensional table? Explain the different dimensions.
What are active and passive transformations?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is InformaticaPowerCenter?
What is target designer and target load order?
