Blog

What is Confirmed, Shrunk Dimensions

Confirmed Dimension:

Dimensions  maintaining  relationship  with  more  than  one  fact  table  are  called  as confirmed dimensions

Shipment (Fact Table)

ShipId
ProdId
ToLoc
FromLoc
ShipDate
UnitShipId
Cost

Shrunk Dimension:

Dimensions which are not directly linked to fact tables are called shrunk dimensions


RELATED COURSES

Get Updates on Tech posts, Interview & Certification questions and training schedules