Hi,

I have faced similar problem before and finally we have eneded up in creating a index to store the data seqentially.

Neither the order by or sort transformation will help in...

Hi,

A very nice article.I have few things to add for this post

1.Why should we bring all the data from the source during incremental load.Why can't we bring the data that...

Hi,

If you are looking for some complex SCD then you can use Kimball Method SSIS slowly Changing Dimension componet

(http://www.codeplex.com/kimballscd).

Hi All,

Thanks a lot for your suggestions.the reason for this in my qa database all the column names are in upper case...

You need to process the cube in order to see the data.Do the full process and verify the data