ETL (Extract, transform, load) Question:
How can we 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 |
| Explain Where do we use semi and non additive facts? | Explain the different Lookup methods used in Informatica? |