As in DWH, we have de-normalized data, and data is kept in a very atomic way, which is easy and efficient way to perform analysis or reporting.
If you are in to designing the data model for your business use case or into data warehousing, understanding the fact and dimensional table is very basic. These concepts are much used in OLAP application rather than OLTP.
So, lets take real world problem and try to understand how fact and dimensional tables are built considering certain design parameters.
#datalake #DWH #ETL #ELT #theDataChannel #TDC #fullLoad #dataanalytics #dataStorage #incrementalLoad #DeltaLoad #loadStratergies #dataLoad #Fact #Dimension #FactTable #DimensionTable #RealTimeUseCase
About Channel:
This Channel is dedicated for people who want to learn and share their ideas or experience related to data and its related technologies. People who are in learn path about data, it is recommended to follow this channel. We ensure you to deliver quality content by covering the most importance and relevant topics.
If you are in learning path about data and haven't yet subscribed for this channel. Please do LIKE,SHARE and SUBSCRIBE and press bell button for instant notification.
FOLLOW US ON:
Facebook: / the-data-cha. .
Instagram: the.data.channel
Whatsapp Group: chat.whatsapp.....
We also recommend Below videos:
1. Database vs Datalake vs DWH vs Datamart Part 1: • Database vs Datalake v...
2. Database vs Datalake vs DWH vs Datamart Part 2: • Database vs Datalake v...
3. Edge Computing: • Six Vs Of Big Data
4. ETL vs ELT, why marketing shifting towards ELT..?: • ETL vs ELT... Why ther...
5. Real Reason for Facebook Crash: • 🔥🔥🔥Real reason for Fac...
6. Types Of Data Part 1: • Types Of Data - Part 1
7. Types Of Data Part 2: • Types Of Data Part 2
8. Importance of Data Top 10 Quotes: • Importance of Data To...
9. Six V`s Of BigData: • Six Vs Of Big Data