Insert else update option in which situation we will use
- 4 Answers
- 10456 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
What is repository manager?
Explain what transformation and how many are there in informatica?
Explian the Process of deployment groups in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can anyone tell me the new features in Informatica 9 Version?
How many ways are there to do 'remove duplicate records in informatica'?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
how tokens will generate?
explain abt ur project architecture?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the tuning lookup transformation - informatica
What are the types of caches in lookup?
What is a surrogate key?
