Notifications
Clear all
Topic starter
15/08/2022 8:35 am
Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.
What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?
- A . Bulk load.
- B . Purge and load.
- C . Use ELT instead of ET
- E . Delta load.
Suggested Answer: D
Explanation:
D. Delta load
Since Oliver needs to migrate changes every hour, a delta load is the best approach.
Explanation:
D. Delta load
Since Oliver needs to migrate changes every hour, a delta load is the best approach.