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  >>  Cognos
 
 


 

 
 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 
How to connect three fact tables?
 Question Submitted By :: Chintu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to connect three fact tables?
Answer
# 1		 
Through surrogate-key.
 
Is This Answer Correct ?    0 Yes 0 No
Vinod Kumar Reddy
 
  Re: How to connect three fact tables?
Answer
# 2		 
vinod kumar reddy told wrong answer.
using pk and fk we can connect 3 fact tables
 
Is This Answer Correct ?    0 Yes 0 No
Ambareesh
 
 
 
  Re: How to connect three fact tables?
Answer
# 3		 
Through primary keys and foreign keys
 
Is This Answer Correct ?    1 Yes 0 No
X
 
  Re: How to connect three fact tables?
Answer
# 4		 
Using conformed diemsion tables
 
Is This Answer Correct ?    0 Yes 0 No
Srini
 
  Re: How to connect three fact tables?
Answer
# 5		 
As per Srini post, Confirmed Dimension is right,
If a dimension table which is shared by more than one fact 
table is called Confirmed Dimension.
But its not advicable, Coz, it will take a time and also it 
going to be trouble.
The primary condition is both the dimension should equal
For eg,Time dimesion.
 
Is This Answer Correct ?    0 Yes 0 No
Shree Uday
 
  Re: How to connect three fact tables?
Answer
# 6		 
hi,this is ramana reddy from chennai.i hope that everone is
correct their way but thing is to that ,we can conncect 1 r
more then one fact table by using "aggregate awareness"
concept and this process we use to call "fact constilation".
 
Is This Answer Correct ?    0 Yes 0 No
Ramana Reddy
 

 
 
 
Other Cognos Interview Questions
 
  Question Asked @ Answers
 
how many types of keys are there i.e primary key and foreign key etc..? IBM1
Can we create reports using OLTP database?How?  3
what is the difference between cascading prompt and drill-thru  3
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS? Virtusa2
What is Render Variable? where u can use?  1
How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?  2
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?  1
difference between imprompt and reportnwt1.1 HSBC1
What are the differences between Cognos 8 and Cognos 7.x version?  1
where do we see the run time of the report ?  1
what is mean of Meta data definistions? IBM2
does query is created for date prompt?  2
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?  3
How many number of cubes can we create on a single model? How can we navigate between those cubes?  1
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .) Kudos-India2
what are the applications of the tabular model ???? iGate4
what r the names of the reports that u prepared??? Covansys9
When we use consume in cognos? IBM1
what is an associated query?  2
What is namespace and what it holds? IBM3
 
For more Cognos 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