- Home
- Blog
- Data Warehousing
- What is Confirmed, Shrunk Dimensions
What is Confirmed, Shrunk Dimensions
Rating: 4
4780
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!
Course Schedule
| Name | Dates | |
|---|---|---|
| Snowflake Training | Oct 19 to Nov 03 | View Details |
| Snowflake Training | Oct 22 to Nov 06 | View Details |
| Snowflake Training | Oct 26 to Nov 10 | View Details |
| Snowflake Training | Oct 29 to Nov 13 | View Details |
Last updated: 03 Apr 2023
About Author
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.
read less
Data Warehousing Articles
- Data Warehouse Interview Questions
- Data Warehouse Tools
- Data Warehouse vs Data Lake
- Data Acquisition – ETL Process In Data Warehousing
- DWH Life Cycle
- Slowly Changing Dimensions ( SCD Type I/II/III )
- Types Of Facts In Data Warehouse
- Types Of Tables In DWH: Facts And Dimensions
- What Are Differences Between OLTP And DWH?
- What Is Data Mart?
- Data Warehousing?
- OLTP VS OLAP - Difference between OLTP and OLAP