Tuesday, 27 August 2013

schema designing in data warehousing and mining

schema designing in data warehousing and mining

I am bit confused between fact and dimension tables and I am not able to
clear my doubt . Thing is I have to design a schema where there is one
keyword table . And corresponding to each and every keyword we have a date
table and site table(that keyword is generated for which site) . Now
having this scenario to work on I am very much confused regarding which
table be assigned as fact and which one as dimension tables . Keyword
table contains key_id and keyword name . Date table contains month , year
and week . Site table contains name of site to which keyword
belongs.Please suggest me architecture of this schema.

No comments:

Post a Comment