Most Asked Cognos Interview Questions and Answers

Cognos Interview Questions and Answers most commonly asked for Experienced PDF, Freshers candidates for Employment.

Why need staging area database for DWH?

Staging area needs to clean operational data before loading into data warehouse.

Cleaning in the sense your merging data which comes from different source

How can create users and permissions in cognos?

in impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc

you can crate users by using USERS PROFILE option……and you can give permissions using ROLE IN C8 and GOVERNERS in C7

What is drill down and slicing and dicing whats the difference between them?

Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.

Slicing and Dicing

While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.

What are components of report studio?

Insertable Objects pane > Properties pane > Explorer bar >Report Viewer

What is difference between view and materialized view?

Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance.

What is slowly changing dimension?

Dimension attribute values may change constantly over the time. (Say for example customer dimension has customer_id,name, and address) customer address may change over time.

What is Cognos Visualizer and Cognos Scripting?

Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically.

Cognos script editor : We can write cognos macros or programs in this tool and can fine tune or process some execution .

What is the difference between a cascading report and drillthru report?why do we go for drill thru report?

Cascading report works based on the condition but drill thru work based on the data item what we select as a drill thru options

What is Snap Shot?

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

What is difference between data mart and data warehouse?

A data mart designed for a particular line of business, such as sales, marketing, or finance.

Where as data warehouse is enterprise-wide/organizational

The data flow of data warehouse depending on the approach.

What is difference between primary key and unique key constraints?

Primary key maintains uniqueness and not null values Where as unique constrains maintain unique values and null values.

What is catalog and types of catalogs in cagonos and which is better?

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

  • personal

  • distributed

  • shared

  • secured

shared catalog is better.

What is Cognos Powerhouse and what is it used for?

Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for Web-based, client/server, or traditional terminal-based access. PowerHouse has gained a worldwide reputation for productivity, reliability, performance, and flexibility.

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.

What is DTM?

DTM transform data received from reader buffer and its moves transformation to transformation on row by row basis and it uses transformation caches when necessary.

What are the types of index?

Bitmap index ,B-tree index, Function based index ,reverse key and composite index. We used Bitmap index in our project for better performance.

How do add dynamic titles in PP?

PowerplayFrom format menu–>title, header & footer–>title–>insert report filename

What is Cognos Reporting tool?

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

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.

What are the different uses of a repository manager?

Repository manager used to create repository which contains metadata the informatica uses to transform data from source to target. And also it use to create informatica user’s and folders and copy, backup and restore the repository.

What you mean by Drill across and what is the difference between drill through, drill across?

Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level if you are using the different report it is drill across and if you are using same report it is drill through.


Popular posts from this blog

TOP Agile Testing Interview Questions and Answers

Latest Agile Testing Interview Questions and Answers

Most Asked ADO.NET Interview Questions and Answers