hai

can we use our relation tables as our dimension tables.or is there any
procedure to convert relational table to dimensional table.


thank you

Typically you want to create dimension tables separate from your
transactional (relational) tables. So if you have a Customer table you would
want to create a DimCustomer dimension table within your data mart or
warehouse.

The dimension tables should have unique surrogate keys that are different
than the source system (business key) and you should only use the columns
that will be useful for reporting and analysis. This is part of best
practices.

-=Steve

"vidhya" wrote:

> hai
>
> can we use our relation tables as our dimension tables.or is there any
> procedure to convert relational table to dimensional table.
>
>
> thank you
>
>
>