Types of Dimensions in Dimensional Data Modelling👉 There are 9 types of Dimensions/metrics when dealing with Dimensional Data Modelling. They are given below:🔹Conformed Dimension🔹Outrigger Dimension🔹Shrunken Dimension🔹Role-Playing Dimension🔹Dimension to Dimension Table🔹Junk Dimension🔹Degenerate Dimension🔹Swappable Dimension🔹Step Dimension✅ Conformed DimensionA Conformed Dimension is a type of Dimension that has the same meaning to all the Facts it relates to.... Continue Reading →
Spark & Hadoop beginner to Advanced Questions
1. What are the different cluster managers provided by Apache Spark? Three different cluster managers are available on Apache Spark. These are: Standalone Cluster Manager: The Standalone Cluster Manager is a simple cluster manager responsible for managing resources based on application requirements. The Standalone Cluster Manager is resilient in that it can handle task failures.... Continue Reading →
Big Data V’s
What is Big Data? Large amount of data which is impossible for traditional data processing and management systems to handle effectively. Examples of traditional systems could be RDBMS, On-Premises Data Centers, Traditional batch processing systems, etc. Big Data is mainly characterized by four V's as follows: (A) Volume - 2.5 Quintillion (2,500,000,000,000,000,000) Bytes of data... Continue Reading →
Azure Learning Resources
Top 9 Azure #dataengineering tools to learn for FREE.....start your Azure journey here.....1. Azure Data Factory.https://lnkd.in/gEmpbyrMProject: https://lnkd.in/gFG2aCgy2. Azure Data bricks.https://lnkd.in/gvFwKxaNproject: https://lnkd.in/gFG2aCgy3. Azure Stream Analytics.https://lnkd.in/g35VbSTv4. Azure Synapse Analytics.https://lnkd.in/gCufskNC5. Azure Data Lake Storage.https://lnkd.in/gcEKjWsc6. Azure SQL database.https://lnkd.in/gmHxqxQX7. Azure Postgres SQL database.https://lnkd.in/grHWJvWZ8. Azure MariaDB.https://lnkd.in/gYSp7MZi9. Azure Cosmos DB.https://lnkd.in/g6jPZA36This is an excellent guide to become azure data engineer. No need to... Continue Reading →
SQL Learning Resources
Learn sql for free and earn 10X salary growth. Yes it possible. Here are the 6 best free resources for learning SQL for free -- --Khan Academy -https://lnkd.in/gCZ5fS7x--SQLZoo - https://sqlzoo.net/--Codecademy - https://lnkd.in/gWyMTS-G--SQLBolt - https://sqlbolt.com/--Udacity - https://lnkd.in/gxpBMteQ--SQL for Web Nerds - https://lnkd.in/gRPT3P5X
Data Warehouse, Datalake, Datamesh
Data is the lifeblood of any modern business. But with so much data available, it can be difficult to know how to store, manage, and analyze it effectively.That's where data warehouse, data lake, lakehouse, and data mesh come in.1. **Data Warehouse:**- 📂 Structured Data: Designed primarily for structured data storage.- 📊 Analytical Focus: Optimized for... Continue Reading →
Cloud Resources
☁️ Cloud whispers secrets of data, and in the hands of engineers, it becomes a symphony of insights that reshape the world.🔰From big data being the most demanding technologies today the demand for cloud such as AWS, GCP or Azure is high, with changing times to have multi-skilled professionals.✔️Talking about what a data engineer must... Continue Reading →
CODEBOX 