Tuesday, December 04, 2012 5:48 PM
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 ?
Tuesday, December 04, 2012 7:52 PM
Tuesday, December 04, 2012 9:20 PMI 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
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.