ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
Question
Tell me one example for junk dimension?
 Question Submitted By :: Data-Warehouse-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
example for junk dimension:

consider a trade company which consists of fact about trading that take places in a share trading firm.in these there may be some facts like mode of trade(which indicates whether the user is trading through phone or online)which will be not related to any of the dimensions such as account,date,indices,amount of share etc.
so these unrelated facts are removed from the fact table and stored as a separate dimension as a junk dimension which will be useful to provide extra information
 
Is This Answer Correct ?    13 Yes 1 No
Arasu
 
Answer
# 2
Itís simply a structure that provides a convenient place to
store the junk attributes.
 
Is This Answer Correct ?    10 Yes 6 No
Palzkumar
 
 
 
Answer
# 3
The dimension which will contain data/flags information is
called junk dimension
 
Is This Answer Correct ?    5 Yes 1 No
Suresh...
 
Answer
# 4
any yes or no like status is an example for junk dimension 
Is This Answer Correct ?    11 Yes 8 No
Madhu
 
Answer
# 5
un wanted data which is not useful fo report generating
purpose tht data will be placed in the particular table that
table is known as junk dimension
 
Is This Answer Correct ?    6 Yes 5 No
Sag
 
Answer
# 6
A junk dimension is a table containing all known or given
combinations of two or more other dimensions. It is then
used as a lookup from a fact table to find the combination
of dimensions that relate to that fact. The purpose is to
declutter and reduce the width of the fact table.
An example might be a [SalesFact] table which references a
junk dimension [SalesExtentionDIM] containing values/SKs
for dimensions of [OnSaleYN] , [SaleCodeSK] , [ColourSK] ,
[baggedYN]
 
Is This Answer Correct ?    1 Yes 1 No
Banjwolf
 
Answer
# 7
Junk Dimension are may be or may not be used
Ex-Gender M/F
student attendance.-yes/No
 
Is This Answer Correct ?    0 Yes 0 No
Gopal
 
Answer
# 8
A Dimension with the type of descriptive information like flog,button or not used describe the key performance indicators known as facts is called as junk dimension

ex: product description,phone,fax, address ,etc..
 
Is This Answer Correct ?    4 Yes 6 No
Srinivas Reddy
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL --- Principal-Finance 1
WHAT IS CONFORMED DIMENSION? Polaris 5
what is indexing ? what are different types of indexes supported by oracle ?   2
What is aggregate awareness?   2
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE Wipro 1
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?   2
Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user IBM 6
What is DTM session?   1
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do IBM 1
How can Oracle Materialized Views be used to speed up data warehouse queries?   3
What is IQD file?   1
What is ?Data Warehousing??   3
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com