Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11165 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
Can informatica load heterogeneous targets from heterogeneous sources?
Design a mapping to load a target table with the following values from the above source?
Why update strategy and union transformations are active? Explain with examples.
Which is the t/r that builts only single cache memory?
How do you load alternate records into different tables through mapping flow?
How do you load only null records into target?
Explain lookup transformation in informatica
can we override a native sql query within informatica? Where do we do it?
What are the advantages of using informatica as an etl tool over teradata?
How do you load first and last records into target table?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is xml source qualifier transformation in informatica?
What is dimensional table? Explain the different dimensions.
Is it possible to use a client with different version than that of its Informatica server?
Design a mapping to load the cumulative sum of salaries of employees into target table?
