Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11151 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
Write the different tools in the workflow manager?
What the difference is between a database, a data warehouse and a data mart?
What is the difference between writing a joiner query in ANSI style and THETA style?
Difference between Data and Index Caches?
How do you change a non-reusable transformation to reusable transformation?
In how many ways we can create ports?
Does an informatica transformation support only aggregate expressions?
Can you generate sequence numbers without using the sequence generator transformation?
What are the components of the workflow manager?
how we can load rejected record's at run time?(not through bad files)
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to generate sequence numbers?
What could be the possible resons of locks by user?
How do you load unique records into one target table and duplicate records into a different target table?
EXL informatica Questions
