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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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
What is Factless fact table? In which purpose we are using 
this in our DWH projects?Plz give me the proper answer.

Thanks,
Ramesh
 Question Submitted By :: Ramesh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 1
It is a fact table which does not contain any measurable data.

EX: Student attendance fact (it contains only Boolean
values, whether student attended class or not ? Yes or No.)
 
Is This Answer Correct ?    5 Yes 0 No
Dirasanchu
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 2
A Factless fact table contains only the keys but there is 
no measures or in other way we can say that it contains no 
facts.


 Generally it is used to intigrate the fact tables.
 
Is This Answer Correct ?    7 Yes 0 No
Samir Kumar Sahoo
 
 
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 3
factLess fact table def as mentioned above..
Where it is used?
These are used particularly to resolve many to many 
relationships,which will create duplicate counts in OLAP 
Cube creation.
Or it can be used to avoid loops which will decrease the 
query performnce while reporting
 
Is This Answer Correct ?    0 Yes 1 No
Asish
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 4
Factless fact tableis used for the  converting the star 
schma into snowflake schema
 
Is This Answer Correct ?    0 Yes 5 No
Eswar
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 5
Factless fact table contains only foreign keys. We can have two kinds of aggregate functions from the factless fact one is count and other is distinct count.
 
Is This Answer Correct ?    0 Yes 1 No
Pratap Gangula
 
  Re: What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Answer
# 6
2 purposes of factless fact

1. Coverage : to indicate what did NOT happen. Like to 
answer questions like which product did not sell well in a 
particular region.

2. Event tracking: To know if the event took place or not. 
Like: Fact for tracking students attendence will not 
contain any measures.
 
Is This Answer Correct ?    0 Yes 0 No
Asha
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
what are different ways of loading data to data warehouse using oracle?  1
why oracle is the best database for data warehousing? HCL2
Explain in simple terms, the concept of Data Mining.  2
What is XMLA ?  1
What is the difference between Oracle Express and Oracle Discoverer?  1
How can we do ETL process in SQL Server? ETL1
2.What is staging area ? HCL3
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.  2
What is the difference between a W/H and an OLTP application?  4
What is ?Data mining??  2
if we increase the number of dimensions will the rows in fact table increase or decrease?? IBM3
How to use the tool Ontobulider  1
what is the difference between aggregate table and fact table ? how do you load these two tables ? Target11
What Oracle features can be used to optimize my Warehouse system?  1
What is an OLAP (On-line Analytical processing) system?  1
What is difference between Business Objects and Hyperion Essbase? Please help me  1
What is Drill by? drill through? iFlex1
what is a hot file, why we need in datawarehousing, where we used in general Thomson2
What is mapplet?  1
What is data merging, data cleansing and sampling?  1
 
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