ETL process. He shows you an article that states that faulty metadata
will lead to poor information from the data warehouse. The executive
team is eager to move forward but the risk of faulty metadata is
making the CIO apprehensive. He reiterates that the report will be
used to explain metadata to the company’s management team. He
reminds you that the team comprises of technical and nontechnical
stakeholders. In your report, you must show why metadata is a major
building block for a data warehouse and how it impacts ETL.
Write a three to five (3-5) page paper in which you:
List and explain three (3) differences between data dictionaries used in
database management systems and metadata that is used in data
warehousing.
Identify three (3) primary reasons why metadata are important in a
data warehouse.
List three (3) significant differences between business and technical
metadata. Explain why each difference is relevant.
Identify and explain three (3) significant points that show the impact
of metadata on the ETL process. Be sure to state where in the ETL
process the impact would occur.
Use at least three (3) quality resources in this assignment. Note:
Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:
Be typed, double spaced, using Times New Roman font (size 12), with
one-inch margins on all sides; citations and references must follow
APA or school-specific format. Check with your professor for any
additional instructions.