Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11513 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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What does “tail –f” command do and what is its use as an Informatica admin.
Enlist the various types of transformations.
expain about the tune parameters?
Differences between version 7.x and 8.x.
What is InformaticaPowerCenter?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are the modules in Power Center
How do you promote a non-reusable transformation to reusable transformation?
Explain the difference between mapping parameter and mapping variable?
What is the difference between a repository server and a powerhouse?
What is a mapplet/worklet in informatica?
what is the -ve test case in your project.
