GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 72 of 111    Print  
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   #1  
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   #2  
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   #3  
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   #4  
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   #5  
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   #6  
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   #7  
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   #8  
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   #9  
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


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape