Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

IS ii madatory to make relationship while creating DSV (Data Source View) in SSAS? Expand / Collapse
Posted Monday, January 20, 2014 1:47 PM



Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 15,510, Visits: 13,170
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.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1532776
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse