WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / uzval_vee
hai
i guess this question comes under scd's itseems,
becoz in scd type1 we will overwrite the oldvalue with new
value.here we dont have any history
Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
How do you promote a non-reusable transformation to reusable transformation?
Differences between connected and unconnected lookup?
Enlist the various types of transformations.
Explain what is informatica metadata and where is it stored?
What is the difference between source qualifier transformations source filter to filter transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
can u any challenge your project?
How can you validate all mappings in the repository simultaneously?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Quickly characterize reusable change?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is Active lock explain
How you know when to use a static cache and dynamic cache in lookup transformation?
How to update a particular record in target with out running whole workflow?