Insert else update option in which situation we will use
- 4 Answers
- 9743 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
as per my knowledge
when we use update strategy transformation we will come
across to use this...insert else update...
let us suppose we have two tables a and b. a is the source
table and b is the target table...let us take b which is
target table contains some matched records with 'a' which
is source table. If source table 'a' is modified and
inserted with some records,here we need to update the
records in the target table...therefore by using the insert
else update option in the session properties of target we
can insert new records and update the existing records
correct me if i was wrong
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / madhavi
if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the difference between procedure and stored procedur?
What is informatica? What exactly are the practical uses in real world
Explain one complecated mapping?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is rank transformation in informatica
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
when we go for unconnected lookup transformation? and why?
What are the different types of olap? Give an example?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
what is worklet and what use of worklet and in which situation we can use it?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Teradata 
