• 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