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.
Sir, Please provide an code example.
ReplyDeleteThanks a lot for giving us such a helpful information. You can also visit our website for imt cdl project
ReplyDelete