Desiging dimension tables

• MuditGupta

  SSCrazy

  Points: 2596

  More actions

  August 13, 2008 at 8:49 am

  #189323

  hi there

  I need some advice regarding creating DIM tables.

  I have a relational table which has composite PK & i want to create a SK in my DIM table ..how should I proceed.

  Thanks

• Jitendra Luniya

  SSC Eights!

  Points: 981

  More actions

  September 5, 2008 at 7:32 am

  #867748

  You can basically create one table defining surrogate key. For example if you have tables like

  Region

  (idRegion

  RegionName

  )

  and

  Country

  (idCountry

  idRegion

  CountryName)

  if your composite key in Country is idRegion and CountryName then you can create a dim table as

  dimCountry

  (idCountry

  RegionName

  CountryName)

  where idCountry will be your surrogate key in the dimension table.

  Regards - JL