Home Forums SQL Server 2005 Business Intelligence IS ii madatory to make relationship while creating DSV (Data Source View) in SSAS? RE: IS ii madatory to make relationship while creating DSV (Data Source View) in SSAS?

  • sneumersky (1/20/2014)


    Hopefully, the initial forum poster got the answers he/she was seeking, and my apologies to Koen for adding my $.02 when I probably did not need to 🙂

    No problem 🙂 Healthy discussions are always appreciated.

    Personally I almost never use FKs in the data warehouse. They stand in the way of my truncate table statements 🙂

    But, the ETL has the responsability though to make sure data integrity is intact. Lookups are done before rows are inserted into a fact table. If the lookup fails, the row has to be dealt with before it goes into the fact table.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP