Oracle Extract transform load (ETL) Question:

How to determine what records to extract?

Oracle ETL Interview Question
Oracle ETL Interview Question

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 mth) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.


Previous QuestionNext Question
What is Full load & Incremental or Refresh load?Do we need an ETL tool? When do we go for the tools in the market?