Home  >  Blog  >   Data Warehousing  > 

What is Confirmed, Shrunk Dimensions

Rating: 4
  
 
4445

Confirmed Dimension:

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

Confirmed Dimension

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.

MindMajix Youtube Channel

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!

 

 

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingSep 24 to Oct 09
Snowflake TrainingSep 27 to Oct 12
Snowflake TrainingOct 01 to Oct 16
Snowflake TrainingOct 04 to Oct 19
Last updated: 20 September 2022
About Author
Himanshika Sharma

Although from a small-town, Himanshika dreams big to accomplish varying goals. Working in the content writing industry for more than 5 years now, she has acquired enough experience while catering to several niches and domains. Currently working on her technical writing skills with Mindmajix, Himanshika is looking forward to explore the diversity of the IT industry. You can reach out to her on LinkedIn