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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SteveCSC

    Impact of timestamp as join key instead of integers

    THank you - your comments have been very helpful!
  2. SteveCSC

    Data Warehousing Certification

    Try the Data Warehouse Institute http://www.dw-institute.com/
  3. SteveCSC

    Reporting Tools high volume of records.

    You should take a good look at MicroStrategy if you plan on accessing large volumes of data (I did not see it in your eval list - it is a ROLAP tool).
  4. SteveCSC

    Dimensional Modeling Question (FACT vs DIM Data)

    If you have all your dimensional information on the fact table, you must then consider how you handle slowly changing dimensions (see Kimball if you don't know this concept). You will have to scan thru all your history on the fact table to do any updates of dimensional information that is either...
  5. SteveCSC

    Impact of timestamp as join key instead of integers

    Can a DBA (or anyone) give me a general idea of the impact of using a timestamp as a join key between the time dimension and a fact table, instead of integer values (three separate columns - day, mo, yr)? Also, is there is difference for indexing the the three columns were text instead of integer?
  6. SteveCSC

    facts on dimension tables

    Thank you. Yes the specific facts do apply only to that dimension, and I think I will address them on a case-by-case basis.
  7. SteveCSC

    facts on dimension tables

    I have a client with many fact columns on their dimension tables. It is my suggestion to remove them - anyone have comments?

Part and Inventory Search

Back
Top