Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Modelling a new warehouse

2 posters

Go down

Modelling a new warehouse Empty Modelling a new warehouse

Post  themitch 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

Back to top Go down

Modelling a new warehouse Empty Re: Modelling a new warehouse

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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