Category Archives: What is SQL Server Analysis Service

What is SQL Server Analysis Service: Chapter 2 (Fact and Dimension?) OLAP data warehouse works across the facts and dimension tables. These are the two parts of representation of data warehouse. FACT: Fact table is the table which calculates the … Continue reading →

In OLTP systems, as the time passes the data increases in the OLTP database. Reports which need to be fetched works on same to database where the live transactions are running. I.e. this database is live database interacting with application … Continue reading →