Q 1. For what reasons ETL functions aremost challenging in a data warehouse envi
ID: 3610446 • Letter: Q
Question
Q 1. For what reasons ETL functions aremost challenging in a data warehouseenvironment.
Q 2. Explain why key restructuring is required?
Q 3. Give a suitable example to describe the situation where a fulldata refresh is
preferable to an incremental load?
Q 4. Regardless of the general acceptance of dimensional modeling,some misperceptions
continue to be disseminated in the industry. Explain followingmisperception briefly:
Marks
I. Dimensional models and data marts are for summary dataonly
II. Dimensional models and data marts are departmental, notenterprise, solutions.
III. Dimensional models and data marts are not scalable.
IV. Dimensional models and data marts are only appropriate whenthere is a
predictable usage pattern.
V. Dimensional models and data marts can’t be integrated andtherefore lead to
stovepipe solutions. Q 1. For what reasons ETL functions aremost challenging in a data warehouse
environment.
Q 2. Explain why key restructuring is required?
Q 3. Give a suitable example to describe the situation where a fulldata refresh is
preferable to an incremental load?
Q 4. Regardless of the general acceptance of dimensional modeling,some misperceptions
continue to be disseminated in the industry. Explain followingmisperception briefly:
Marks
I. Dimensional models and data marts are for summary dataonly
II. Dimensional models and data marts are departmental, notenterprise, solutions.
III. Dimensional models and data marts are not scalable.
IV. Dimensional models and data marts are only appropriate whenthere is a
predictable usage pattern.
V. Dimensional models and data marts can’t be integrated andtherefore lead to
stovepipe solutions.
Explanation / Answer
Q 1. For what reasons ETL functions aremost challenging in a data warehouse envi
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.