Oracle Extract transform load (ETL) Question:
Download Questions PDF

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 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.

Download Oracle ETL Interview Questions And Answers PDF

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?