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?

  • A DSV will auto-detect foreign key constraints between a fact and a dimension, but foreign keys add unncessary overhead to an ETL process.

    The approach to create the relationships in the DSV is, in my opinion, the more performant way. The data modeler on your team (if not you) may not be too happy with you though ;-)....