Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Fact Table be a view?

Status
Not open for further replies.
sun96

sun96

Programmer
Apr 16, 2002
2
SG
Can the fact table of a data warehouse be a View (from Microsoft SQL Server), or must it be a physical table?

Any advice would be greatly appreciated. :->
 
Sort by date Sort by votes
SURE!
I've used a view that makes the union of 2 other views and it works fine...
 
Upvote 0 Downvote
one little warning about views:
if you produce some values in your view - your cleansing will be
much more difficult...and even impossible in some cases...
because you cannot set values to views...
Issahar
senior software engineer
Israel
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
383
Vary88
Vary88
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
666
k5tm
k5tm
vktrez
  • Locked
  • Question
Best OLAP Tools 1
Replies
1
Views
410
fominlena
fominlena
isoman4not5
  • Locked
  • Question
Is it possible to derive a recurring date based upon a single date?
Replies
0
Views
378
isoman4not5
isoman4not5
chainedtodesk
  • Locked
  • Question
update AS400 table from MS Access db
Replies
0
Views
357
chainedtodesk
chainedtodesk

Part and Inventory Search

Sponsor

Back
Top