We are getting following error when processing the one of our dimensions ? Any clue why ? and how to fix it ?
"Conversion failed when converting the nvarchar value ""to data type smallint . Object variable or with block variable not set"
Another question , During CPM311 class we been told , it is good idea to process all dimensions and optimize the application after every data load ? What you guys think about it?