SunTrust interview question

what is a type 2 dimensions

Interview Answer

Anonymous

7 Sept 2015

Type 2 dimensions are used in Data Warehousing to maintain history. The surrogate keys of these dimensions are mapped to the transaction data and enabling a star schema