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
2258 Enrolled
3370 Enrolled
1256 Enrolled
1563 Enrolled
2925 Enrolled
4025 Enrolled
1045 Enrolled
1578 Enrolled
1956 Enrolled
1463 Enrolled
1090 Enrolled
3063 Enrolled
880 Enrolled
1899 Enrolled
3350 Enrolled
3766 Enrolled
1458 Enrolled
3780 Enrolled
1385 Enrolled
75 Enrolled
Get Updates on Tech posts, Interview & Certification questions and training schedules