Janie.Carlisle (10/30/2013)
K,Thanks for help. Was trying to avoid duplicate work but not sure it's possible. Don't really see the logic of pushing the data from an ERP into a DW and then into SQL but I grew up in the world of Keep It Simple. 🙂
A datawarehouse is still the same as a regular SQL Server database. It's just more denormalized,, which is a modelling technique.
If you can get it into the DW, you can get it into SQL.
Unless you mean Teradata with DW, that's something else 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP