What is surrogate key? Surrogate key is nothing but unique identifier assigned to each row in a dimension table. Isn’t simple? Yes. For one, this might raise few questions, because what about primary key, its also unique in nature and assigned to each row. Then, how it differs from primary key of a table, what... Continue Reading →
AWS Certification
FREE AWS Certificate by Amazon that you can't miss in 20231. Getting Started with Data Analytics on AWS🔗https://lnkd.in/dwRhRAzM2. Practical Data Science on the AWS Cloud Specialization🔗https://lnkd.in/d3-3GZbG3. Getting Started with AWS Machine Learning🔗https://lnkd.in/dhAp-Vjh4. Introduction to Machine Learning on AWS🔗https://lnkd.in/detfDCWA5. Hands-on Machine Learning with AWS and NVIDIA🔗https://lnkd.in/dgGvATq26. AWS Fundamentals Specialization🔗https://lnkd.in/dSV9jhRz7. Building Modern Python Applications on AWS🔗https://lnkd.in/dQAinFGy8. AWS... Continue Reading →
Types of Dimensions in DWH
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 →
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 