Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, January 20, 2014 1:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:40 AM
Points: 13,735, Visits: 10,696
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 LessThanDot.

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

Add to briefcase ««12

Permissions Expand / Collapse