How To Determine What Records To Extract?

1.	How To Determine What Records To Extract?
Answer» When addressing a table some DIMENSION key must REFLECT the NEED for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1ST of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which GETS reset when record changes. When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.

Answer»

When addressing a table some DIMENSION key must REFLECT the NEED for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1ST of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which GETS reset when record changes.

When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.

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?