I made the jump from OLTP DBA to DataWarehouse DBA 4 years ago and couldn't be happier. The BI system I support has a footprint of approximately 40 TerraBytes and...
The only problem I encountered during testing was that the target table clustered indexes would sometimes get created with their columns in the wrong order....