Dinesh's Blog :::: Being Compiled ::::
Showing posts with label
Fact Table
.
Show all posts
Showing posts with label
Fact Table
.
Show all posts
Friday, July 29, 2016
Fact Loading: Switching a loaded temporary table into an empty partition of the fact table
›
Fact table in data warehouses are always partitioned and with most of solutions, it is partitioned on a date key. Generally, we use SSIS f...
Thursday, July 28, 2016
SSIS - Fact Loading with Dimension Type II and Dimension Type I
›
The Dimensional Modeling in data warehousing, either using Star or Snowflake schema is still the most famous structure applied and widely ...
Saturday, May 23, 2015
Fact Table: Clustered index on date key is enough or partitioning should be done with it?
›
Fact table in a data warehouse (or a large table in an OLTP database) always holds millions of records and we keep on adding records large...
›
Home
View web version
