Problems Q1. For what reasons ETL functions are most challenging in a datawareho
ID: 3610437 • Letter: P
Question
Problems
Q1. For what reasons ETL functions are most challenging in a datawarehouse
environment.
Q2. Explain why key restructuring is required? Q 3. Give a suitableexample to describe the situation where a full data refreshis
preferable to an incremental load?
Q4. Regardless of the general acceptance of dimensional modeling,some misperceptions
continue to be disseminated in the industry. Explainfollowing misperception briefly:
I. Dimensional models and data marts are for summary dataonly
II .Dimensional models and data marts are departmental, not enterprise,solutions.
III. Dimensional models and data martsare not scalable.
IV. Dimensional models and data martsare only appropriate when there is a
predictable usage pattern.
V. Dimensional modelsand data marts can’t be integrated and therefore leadto
stovepipe solutions.
Explanation / Answer
Dear, 1) ETL functions are most challenging in a data warehouseenvironment because of the nature of the source systems. Most ofthe challenges in ETL arise from the disparities among the sourceoperational systems. The following list of reasons for the types ofdifficulties in ETL functions. => The source systems are very diverse and disparate.
=> There is usually a need to deal with source systems onmultiple platforms and different operating systems. => Many source systems are older legacy applicationsrunning on obsolete database technology. => Generally, historical data on changes in values are notpreserved in source operational systems. Historical information iscritical in a data warehouse. => Quality of data is dubious in many old source systemsthat have evolved over time. => Source system structures keep changing over timebecause of new business conditions.ETL functions must also bemodified accordingly. 2) Key restructuring can be necessary if data required bydecision support queries is missing or incorrect.The need was for adata warehouse for managing global corporate accounts for bettertactical and strategic decisions. I hopethis will helpful foryou............. I hopethis will helpful foryou.............
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.