Breaking News
Loading...
Friday 7 October 2011

Cognos Interview Question and Answers 2

04:15
11. What are components of report studio?
  • Insert able Objects pane
  • Properties pane
  • Explorer bar
  • Report Viewer
12. What is Snap Shot?

Snapshot is a static datasource it is a picture of of report once u created a snapshot report u can't add a data item.

13. How do you define a cube?

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing.

14. What is the Difference between PowerPlay transformer and power play reports?

Powerplay transformer' is an ‘MOLAP’ tool using which one can create multi dimensional structure called “CUBE”.
Powerplay for reports is used to generate report from the cube.Only one report can be generated from one cube.If u want ‘n’ reports u must create ‘n’ cubes.

15. What is cube size?

2.0 GBIt depends on ur project requirements.

16. What is meant by Junk Dimension?

The Junk Dimension also called as garbage dimension.
A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.

17. What is transformer?

Transformer is used for building the Cubes (Multidimensional Structure used for OLAP processing).

18. What is catalog and types of catalogs in cagonos?

A catalog is a file containing the information (Database tables) that Impromptu users need to create reports.
personal
distributed
shared
secured

19. What is Cardinality?

Relationships exist between two query subjects. The cardinality of a relationship is the number of
related rows for each of the two query subjects. The rows are related by the expression of the relationship;
this expression usually refers to the primary and foreign keys of the underlying tables.

20. How to join multiple db in catalog?

Mutiple database could not be connected in a single catalog. So that we use hotfile for thispurpose.

<< 1 2 3 4 5 >>

Share This :
Tags:

0 comments:

Post a Comment

 
Toggle Footer