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 TouchToneTommy 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: *

  • Users: SteveCSC
  • Content: Threads
  • Order by date
  1. 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?
  2. 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