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

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.

Download Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Where do we use semi and non additive facts?Explain the different Lookup methods used in Informatica?