February 17, 2006 at 9:48 pm
Hi,
My current DB is not using the SQL2k native feature
to maintain my table relationship.
We need to build a impact analysis tool
to know any modification to our application value,
we will know the 'impact' to other table and to
valid whether user are able to proceed.
Hence, we need to build a fact table which is
a denormalize table from our normalize tables. This is
give us the relations between tables in a denormalize
form. So, our fact table are huge in size.
Do anyone know how to optimize this
denomalize table in order to achieve
the same objective of having a fact
table that is small in size.
February 20, 2006 at 8:00 am
This was removed by the editor as SPAM
December 23, 2009 at 3:46 pm
denormalized the dimension tables by functional group.
the fact table should contain mostly aggretable data, numbers/amounts.
Avoid using text in the fact tables.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply