Friday, 27 September 2013

Top 10 Cognos Interview Questions & Answers

By svr 22:13 Leave a Comment
The article is about "Top 10 Cognos Interview Questions & Answers" which are given in a simple manner. These question and answers are very helpful to the students while facing interview. 




1.  Define Cognos?


Ans: Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.



2.  What are the advantages of Cognos?

Ans: Advantages of Cognos:                
  1. Planning
  2. Analysis
  3. Forecasting
  4. Scorecarding


3.  Explain the difference between data mart and data warehouse?

               
Ans: A data mart intended for a particular line of business, such as sales, marketing, or finance.
Where as data warehouse is enterprise-wide/organizational.




4.  What are the different types of prompt in Cognos?

Ans: Types of prompt:            
  1. Value prompt
  2. Date prompt
  3. Time prompt
  4. Date and time prompt
  5. Text Prompt



5.  Explain the components of Report Net?

               
Ans: Components of Report Net are:
  1. Framework manager
  2. Cognos connection
  3. Query Studio
  4. Report Studio



6.  What is Cognos Connection?


Ans: Cognos Connection is a Web portal for Cognos 8 and a component which interacts with the Content Store. It is a frontend to distribute, locate, run, arrange, and view organization's business intelligence data.



7.  Explain about the three important fundamental themes in a data warehouse?
               
Ans: The three important fundamental themes are :
  1. Drilling Across
  2. Handling Time
  3. Drilling Down



8. Define Drill Through?


Ans: Drill-through reporting allows you to link from one report to another. A Drill Through id developed with two reports.
  1. Parent Report
  2. Child Report



9. What are the components of report studio?

               
There are four components of report studio are:
  1. Insertable Objects pane
  2. Report Viewer
  3. Explorer bar
  4. Properties pane



10. What are datastores in Cognos?


Ans: Data sources, also known as query databases, are relational databases, dimensional cubes, files, or other physical data stores that can be right to use through IBM Cognos8. Application Tier Components use data source connections to access data sources.

0 comments:

Post a Comment