Ask
Login
0
5.5kviews
Explain ETL phases in creating a data warehouse.
written 8.9 years ago by gravatar for teamques10 teamques10 ★ 70k modified 3.6 years ago by gravatar for sagarkolekar sagarkolekar ★ 11k
advanced database management systems
ADD COMMENT EDIT
1 Answer
1
28views
written 8.9 years ago by gravatar for teamques10 teamques10 ★ 70k
ETL for fact tables.
ETL for dimension tables.
Write procedure for all data loads.
Organise data staging area and test tools.
Plan for aggregate tables.
Determine data transformation and clearing rules.
Establish comprehensive data extraction rules.
Prepare data mapping for target data elements.
Determine all the data sources, both internal …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.