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
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?