Tag Archives: Unknown dimension

Populate your dimensions with Unknown Members

Normally in every dimension load my first task is to insert the unknown value in the dimension table. This is tedious and time consuming task if dimension has many columns with different data types. And to make the script and … Continue reading

Posted in SSIS, T-SQL | Tagged | Leave a comment