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

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

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

Free Demo for Corporate & Online Trainings.

Full Name

E-mail Address

Course Name

Phone Number *

Message