Blog

What is Confirmed, Shrunk Dimensions

  • (4.0)
  • | 2147 Ratings
2167

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.

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!


Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.


DMCA.com Protection Status
Previous
Next

Drop us a Query


Categories

VIEW MORE

Popular Courses in 2019

OpenStack Training

1112 Learners

Hadoop Training

1090 Learners

Python Training

2116 Learners
Close
Close