Hi Vincent,

Thanks for the enriching discussion about

whether To impart the ODS as middle layer.

I am pretty excited to know how we can

Implement an ODS in an environment where

both the source and target databases are

from Relational SQLSERVER 2005.

If you would provide me DO's and DONT'S

of implementation methodology with a

Suitable example especially dealing with the

"INCREMENTAL LOAD" will be greatly helpful to my task.

Thanks,

Vijay