What Are The Various Methods Of Getting Incremental Records Or Delta

1.	What Are The Various Methods Of Getting Incremental Records Or Delta Records From The Source Systems?
Answer» One foolproof method is to maintain a field CALLED 'Last Extraction Date' and then IMPOSE a condition in the CODE SAYING 'current_extraction_date > last_extraction_date'. One foolproof method is to maintain a field called 'Last Extraction Date' and then impose a condition in the code saying 'current_extraction_date > last_extraction_date'.

What Are The Various Methods Of Getting Incremental Records Or Delta Records From The Source Systems?

Answer»

One foolproof method is to maintain a field CALLED 'Last Extraction Date' and then IMPOSE a condition in the CODE SAYING 'current_extraction_date > last_extraction_date'.

One foolproof method is to maintain a field called 'Last Extraction Date' and then impose a condition in the code saying 'current_extraction_date > last_extraction_date'.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Various Tools? - Name A Few.
Where Do We Use Connected And Un Connected Lookups
How To Fine Tune The Mappings?
Give Some Etl Tool Functionalities?
Give Some Popular Tools?
What Are Snapshots? What Are Materialized Views & Where Do We Use Them? What Is A Materialized View Do?
How To Determine What Records To Extract?
What Are The Various Transformation Available?
What Are Parameter Files ? Where Do We Use Them?
What Are The Different Lookup Methods Used In Informatica?

What Are The Various Methods Of Getting Incremental Records Or Delta Records From The Source Systems?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment