Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Textual Facts in Fact Table

Answered Textual Facts in Fact Table

  • Tuesday, December 04, 2012 5:48 PM
     
     
    Sign In to Vote
    0

    I have a fact table with URL field. It is because a grain of fact will have its own URL. I heard that Fact table should not have textual facts. So, do I need to dimensionalize this URL field ?

    What if I have 100s of those type of fields ? Do I need to created separate tables for all of those fields ?

     

All Replies

  • Tuesday, December 04, 2012 7:52 PM
     
     
    Sign In to Vote
    0

    I heard that Fact table should not have textual facts. So, do I need to dimensionalize this URL field ?


    For best practice/performance you should create a dimension table for the url's with a numeric id (integer) as primary key and use this key in your fact table.

    Olaf Helper

    Blog Xing

     
  • Tuesday, December 04, 2012 9:20 PM
     
     
    Sign In to Vote
    0
    I have 100s of those type of attributes. Should they all be dimensionalized ? What we do in real practice ?
     
  • Monday, December 10, 2012 8:59 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    select the distinct data from all the 100 columns and put it in only 1 dimension(DimMailId(surrogate key, mail id )) table and use the surrogate key to link all the fact table field.

    eg

    dimMail

    1 a@abc.com

    2 b@abc.com

    fact

    officemailid perMailID 

    1 2

    Regards,

    Vipin