question archive With the following data attributes by your business analyst, How do you define and build your data warehouse, so that effective reports can be generated
Subject:Computer SciencePrice: Bought3
With the following data attributes by your business analyst, How do you define and build your data warehouse, so that effective reports can be generated.
a). What sort of data quality issues are found in the given data ?
b). How do you overcome data quality issues using data pre processing methods?
c). What are the fact tables, dimension tables and surrogate keys are required to build
the data warehouse?