ans.
In simple term in data warehouse data is stored. From this stored data, management make decision by looking at reports or by a data analysis tool.
In Microsoft the BI tool is Analysis Services , Reporting Services , Integration Services.
In the data warehouse more focus on data modelling, normalization and optimizing data. Deciding on Star schema (OLAP applns. - Fact Dimension Table) or Snowflake Schema ( RDBMs applns.).
No comments:
Post a Comment