Mindmajix

What is Confirmed, Shrunk Dimensions

Confirmed Dimension:

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

Screenshot_9

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

Screenshot_10


0 Responses on What is Confirmed, Shrunk Dimensions"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.