Modelling a new warehouse

View previous topic View next topic Go down

Modelling a new warehouse

Post  themitch on Fri Oct 18, 2013 12:20 pm

Hi

I'm new to all this and am just modelling my first star schema. Was just wondering about how people type columns in their dimension/fact tables - I was speaking to someone the other day and they set all their text fields to be Varchar2(255), all their number columns to be number, and all dates fields to be Date. That way, any upstream change didn't require model changes in the DW.

Is this typically what others do, too? Or do you explicitly type fields as required, ie using different string lengths, different number precisions, etc.?

Thanks

themitch

Posts : 1
Join date : 2013-10-18

View user profile

Back to top Go down

Re: Modelling a new warehouse

Post  ngalemmo on Fri Oct 18, 2013 2:10 pm

Depends on your database and BI tool. Some DB's will store time in DATE types, while others require using the TIMESTAMP type.

As far as VARCHAR goes, having everything at 255 can be a pain for users if the BI/reporting tool they are using sizes columns according to their declared size.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum