12.9. EXERCISES
Match the columns:
destructive merge
full refresh
character set conversion
derived value
immediate data extract
initial load
file comparison method
data enrichment
Type 1 dimension changes
code generator
use static data capture
EBCDIC to ASCII
technique of last resort
overwrite old value
new record supercedes
average daily balance
complete reload
make data more useful
create extraction program
real-time data capture
As the ETL expert on the data warehouse project team for a telecommunications company, write a memo to your project leader describing the types of challenges in your environment, and suggest some practical steps to meet the challenges.
Your project team has decided to use the system logs for capturing the updates from the source operational systems. You have to extract data for the incremental loads from four operational systems all running on relational databases. These are four types of sales applications. You need data to update the sales data in the data warehouse. Make assumptions and describe the data extraction process.
In your organization, assume that customer names and addresses are maintained in three customer files supporting three different source operational systems. Describe the possible entity identification problem you are likely to face when you consolidate the customer records from the three files. Write a procedure outlining how you propose to resolve the problem.
You are the staging area expert in the data warehouse project team for a large toy manufacturer. ...
Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.