Category Archives: Data Warehouse

Lookup Table

Posted on May 9, 2011 by

Just a concept. It has been already discussed by data management experts. But, I just renew the thoughts. What is OTLT (One True Lookup Table) or common lookup table or single source lookup table? It is a place or a … Continue reading →

Posted in Data Warehouse, SSIS | Tagged , | Leave a comment

Next step in Data Warehouse

Posted on January 15, 2010 by

Parallel Data Warehouse – It is a next level of Data Warehouse scenario to an organization. This helps organization to have low cost multi terabyte Data Warehouse to server millions of customer. PDW is introduced with SQL Server 2008 R2. for more information you … Continue reading →

Posted in Data Warehouse | Tagged , , | 2 Comments