PinnedMuhammad Salah ElOkda·Oct 12, 2024Data Modeling Part 3: An Introduction to Dimensional Modelling (Kimball’s Technique)In Part 2, we introduced the Enterprise Data Warehouse (EDW) data model, a more sophisticated approach that organizes your data warehouse…
PinnedMuhammad Salah ElOkda·Oct 6, 2024Data Modeling Part 2: An Introduction to Enterprise DWH(Inmon’s Technique)In Part 1, we introduced the One Big Table (OBT) data model, a simple yet effective method where all relevant data for a specific business…
PinnedMuhammad Salah ElOkda·Sep 28, 2024Data Modeling Part 1: An Introduction to the One Big Table (OBT) TechniqueData modeling
Muhammad Salah ElOkda·Apr 20, 2019Slowly Changing Dimension in Data WarehouseSCD (Slowly Changing Dimension) is a very important concept in ETL and Data Warehouse in general.
Muhammad Salah ElOkda·Jan 26, 2019Introduction to RPA (Robotic Process Automation)Everyday we hear about the revolution of AI and computers that is gonna replace our jobs and how many jobs will disappear in our days.
Muhammad Salah ElOkda·May 16, 2018Joining and Merging sources in Informatica PowerCenterHello ETL Developers, Today I am going to explain different ways to join or merge data sources using Informatica PowerCenter.