Oracle Extract transform load (ETL) Question:
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.
| Previous Question | Next 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? |