This type of fact table describes what has happened over a period of time. For example, this fact table may describe the total sales by product by store by day. The facts for this type of fact tables are mostly additive facts.
Saturday, 21 May 2022
Accumulated Fact Table in DWH
Labels: SQL SERVER, SSIS, SSAS, SSRS
DWH
Subscribe to:
Posts (Atom)
Popular Posts
-
Delay Validation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this pro...
-
There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. I...
-
Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). While we are try...
-
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco...
-
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There ...