Basics - can a dimension table contains numeric values?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 72 of 111

can a dimension table contains numeric values?

Total Answers and Comments: 9

Last Update: September 23, 2008 Asked by: sunil

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 08, 2006 11:34:25

kalyanswarna

Member Since: August 2006 Contribution: 1

RE: can a dimension table contains numeric values?

No.Only ZFact Table having Numeric Fields.Thanks,Kalyan.

Is this answer useful? Yes | No

August 14, 2006 02:32:45

Anwar

RE: can a dimension table contains numeric values?

Yes.But those datatype will be char (only the values can numeric/char)

Is this answer useful? Yes | No

September 01, 2006 13:40:13

mamatha

RE: can a dimension table contains numeric values?

hi sunil

yes, we can have numeric values in dimensional table but these are not

frequently updated as dim table contains constent data but only on some occassions it can change

mamatha

Is this answer useful? Yes | No

October 22, 2006 02:44:43

sudharshan

RE: can a dimension table contains numeric values?

yes ,

It may contain the numeric values but not summerised informations

Is this answer useful? Yes | No

May 30, 2007 16:49:24

hs_water

Member Since: May 2007 Contribution: 1

RE: can a dimension table contains numeric values?

come on, isn't surrogate key numeric?

Is this answer useful? Yes | No

August 03, 2007 12:49:04

HopHead

RE: can a dimension table contains numeric values?

A dimension table can contain anything you want - it is the business requirements around each data element that drive the data model.

Eg: Your company makes bicycles. Frame size is part of the product.

It's not a fact - it makes no sense to add/average/sum the frame size.

It *IS* something you group/sort/filter on. "How many bikes with 19 inch frames were sold by region ?"

WHERE ProductDimension.FrameSize = 19

Is this answer useful? Yes | No

December 13, 2007 04:17:35

Sivakumar.R

Member Since: December 2007 Contribution: 14

RE: can a dimension table contains numeric values?

Dimension table will have only textual values only.Some dimension table will have numeric values for eg.Cust number in a Cust_dim only thing here to remember is the object type of the Cust number should always a Char type.for ref you can see these in the universe just right click the cust number object and view definition tab of the object , there you can see a list down box will show your "object Type" to be Char.

for further query pls do send a mail r.isrepus@gmail.com

Thanks & Regards,
Sivakumar.R

Is this answer useful? Yes | No

January 04, 2008 03:11:22

ThomasB

Member Since: January 2008 Contribution: 4

RE: can a dimension table contains numeric values?

Absolutely!

For example, a perishable product in a grocery store might have SHELF_LIFE (in days) as part of the product dimension. This value may, for example, be used to calculate optimum inventory levels for the product. Too much inventory, and an excess of product expires on the shelf, while too little results in lost sales.

Is this answer useful? Yes | No

September 23, 2008 11:17:49

sixto.dsilva

Member Since: March 2008 Contribution: 50

RE: can a dimension table contains numeric values?

As commented by Gurus in this question , I think dimension table can have numeric values also since it is business requiremnt driven model. For example you can a currency table which will have the currency conversion values. which you can used in fact table for conversion values.

Is this answer useful? Yes | No

Go To Top