Q 1.For what reasons ETL functions are most challenging in a datawarehouse envir
ID: 3610490 • Letter: Q
Question
Q 1.For what reasons ETL functions are most challenging in a datawarehouse
environment. Marks5
Q 2. Explain why key restructuring is required?Marks5
Q 3. Give a suitable example to describe the situationwhere a full data refresh is
preferable to an incremental load? Marks5
Q 4. Regardless of the general acceptance of dimensionalmodeling, some misperceptions
continue to be disseminated in the industry. Explainfollowing misperception briefly:
Marks 15 (3 for each)
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 marts are notscalable.
IV.Dimensional models and data marts are only appropriate when thereis a
predictable usagepattern.
V.Dimensional models and data marts can’t be integrated andtherefore lead to
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
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.