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


Please Help Members By Posting Answers For Below Questions

Separate from an archive server and a powerhouse?

491


How do you promote a non-reusable transformation to reusable transformation?

658


Differences between connected and unconnected lookup?

609


Enlist the various types of transformations.

554


Explain what is informatica metadata and where is it stored?

605






What is the difference between source qualifier transformations source filter to filter transformation?

576


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

804


can u any challenge your project?

1602


How can you validate all mappings in the repository simultaneously?

753


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1700


Quickly characterize reusable change?

687


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?

1455


what is Active lock explain

2366


How you know when to use a static cache and dynamic cache in lookup transformation?

1334


How to update a particular record in target with out running whole workflow?

1154