Data Warehousing Community Forum
March 21, 2019, 07:59:59 am

Pages: [1]   Go Down
  Print  
Author Topic: Adding additional columns to a a dimension table  (Read 312 times)
sjobs12@yahoo.com
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: December 26, 2018, 11:14:26 am »

I have a star schema data warehouse. In dimension table T1, I have a BK (BK1) and several data columns (Col1, Col2 and Col3). Business wants to add two more columns (ColX and ColY) to the table for their use which are not part of the dimension. All the data columns are part of Type 2 SCD except these two columns. I am of the opinion that these two columns should not be part of Type 2 SCD for this dimension table as they are not part of the dimension. Any thoughts?
Logged
Pages: [1]   Go Up
  Print  
Jump to: