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!

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

Recent content by datadb

  1. datadb

    Schema question for multiple fact tables

    Thank you very much for the replies. I have modeled many OLTP databases, but not any for a data warehouse. I did pickup the Dimensional Modeling edition of the DW Toolkit, which is very helpful. I have read somewhere on the web about including sales information in page_event if a page had a...
  2. datadb

    Schema question for multiple fact tables

    Thanks for the input. John- Actually, I do have that book. I have only read portions , however, and I don't see anything in the TOC about clickstream analysis. I will need to dig into that deeper (maybe there is a newer edition?). I guess it comes down to this- is ok for me to have a...
  3. datadb

    Schema question for multiple fact tables

    Hello, I have been thinking about the best schema for a DW for clickstream analysis including sales. What comes to mind first for web behavior is a page_view fact table with dimensions like session, user, and referrer. We also want to track sales, however, in relation to this behavior. So, can...

Part and Inventory Search

Back
Top