How to determine what records to extract?
Submitted by: AdministratorWhen 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.
Submitted by: Administrator
Submitted by: Administrator
Read Online Oracle ETL Job Interview Questions And Answers
Top Oracle ETL Questions
☺ | What are the various methods of getting incremental records or delta records from the source systems? |
☺ | What is partitioning? What are the types of partitioning? |
☺ | Where do we use connected and un connected lookups? |
☺ | What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
☺ | Compare ETL & Manual development? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |