Thank you for the response Andrew.

There is no luck with indexed view replication. In order to have this working we went a different route.

* We did straight Table --> Table replication.

* On the destination created a view (with all the conversion date --> small datetime) on the destination table.

At this point we did not care on the performance and had to get data moving. Reason for not looking into performance is we are planning to upgrade the DW to SQL 2012 that way there are no legacy data types.

Thank you for looking into and throwing out suggestions....