Testing Data Mart as Data Source for SSAS

I am new at this so if I didn't explain well feel free to ask questions.

Current Scenario - Star Schema:
Database - TESTDM DimensionA PrimaryKeyA AttributesA DimensionB PrimaryKeyB AttributesB DimensionC PrimaryKeyC AttributesC FactTableA PrimaryKeyFTA DimAForeignKey DimBForeignKey

Is this enough to begin loading the data from flat files and other database sources,? Do data sources require to have relationships?

more ▼

asked Sep 10, 2011 at 11:20 AM in Default

SSASLearn gravatar image

1 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
The data source need not have relationships, however there should be relationships in the datamart.
more ▼

answered Sep 11, 2011 at 10:45 PM

aRookieBIdev gravatar image

2.3k 52 57 61

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 10, 2011 at 11:20 AM

Seen: 614 times

Last Updated: Sep 10, 2011 at 07:49 PM