ALLInterview.com :: Home Page KalAajKal.com
 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                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
3.What is fact less fact ?
 Question Submitted By :: Venkatesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 3.What is fact less fact ?
Answer
# 1		 
there is no facts in the fact table.that table is called 
factless fact table
 
Is This Answer Correct ?    0 Yes 6 No
Sudheer.r
 
  Re: 3.What is fact less fact ?
Answer
# 2		 
A fact table which is having only foreign keys.There is no
measures
 
Is This Answer Correct ?    15 Yes 1 No
Saravanan
 
 
 
  Re: 3.What is fact less fact ?
Answer
# 3		 
A fact table contains only the keys ie foreign keys but no 
measures(numerics) is known as factless fact table.





A Fact Table having no Facts is known as Factless Fact 
Table.
 
Is This Answer Correct ?    7 Yes 1 No
Samir Kumar Sahoo
 
  Re: 3.What is fact less fact ?
Answer
# 4		 
Fact less fact table is  without any Numerical 
measurement , only  contain key value like Foreign key
 
Is This Answer Correct ?    0 Yes 0 No
Ashok
 
  Re: 3.What is fact less fact ?
Answer
# 5		 
There can be only two aggregate functions in a fact less fact table....count and distinct count on the foreign keys.
 
Is This Answer Correct ?    1 Yes 0 No
Pratap Gangula
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
wht is degenerated dimension ?it's uses? CTS8
What is the difference between Oracle Express and Oracle Discoverer?  1
what are the types of dimension tables Infotech9
4.Explain Snowflkeschema ? HCL6
How can Oracle Materialized Views be used to speed up data warehouse queries?  3
How to use the tool Ontobulider  1
What is DTS ?  1
What is the "junk dimension"? Give with examples?  7
What is data merging, data cleansing and sampling?  1
Which kind of index is preferred in DWH?  1
What is staging area?  7
What is difference between a connected look up and unconnected look up?  1
3.What is fact less fact ? HCL5
What is up date strategy and what are th options for update strategy?  2
2.What is staging area ? HCL3
What are CUBES?  2
What is MDX? TCS1
What is Drill by? drill through? iFlex1
What Oracle features can be used to optimize my Warehouse system?  1
Hierarchy of DWH? Accenture1
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com