A degenerate dimension happens when the dimension attribute is stored as part of a fact table, but not in a separate dimension table. These dimensions are keys for which there is no other attribute. In a data warehouse, they are often used as the result of a query to analyses the source of numbers that are collected in a report. We use these values to detect transactions in an OLTP system.
Sunday, 22 May 2022
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... -
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco... -
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 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 ...