Confirmed Dimension:

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

Confirmed Dimension

Subscribe to our youtube channel to get new updates..!

Shipment (Fact Table)

ShipId
ProdId
ToLoc
FromLoc
ShipDate
UnitShipId
Cost

Enhance your IT skills and proficiency in Data Warehousing by taking up the Informatica Training.

Shrunk Dimension:

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

Shrunk Dimension

Explore Informatica Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!