ETL Tip- How to Handle Null vs the Blank fields in Data Warehouse

While populating the data warehouse ETL team is always confused as to how to handle the "Logically NA" values of data. Here are some suggestions in that regards, -What does "Logical Nulls" means? There are always some cases in the data model when there is no data available for a field in some cases. Such… Continue reading ETL Tip- How to Handle Null vs the Blank fields in Data Warehouse

ETL Tip- How to implement Surrogate Keys & Constraints in Data Warehouse?

his article is to explain how to implement the Surrogate keys from a logical dimensional model to a physical DBMS. There have been some clear cut guidelines on this matter from Ralph Kimball & Group but some people still manage to make a mess out of it , so it seems that it should be… Continue reading ETL Tip- How to implement Surrogate Keys & Constraints in Data Warehouse?