Patni Computer Services (PCS) Cognos Interview Experience

Hi all,

I attended Cognos Interview for Patni Computer Services. The lady who interviewed me was Ms. Shakti Swarup Das.

The following are the Questions.

Cognos Questions:
1.Explain the Cognos Architecture?
2.What is Singleton?
3.What is Fact less Fact table?
4.Diff b/w Prompts and Conditional Blocks?
5.Diff b/w Level span and Group span?
6.What is Conditional Formatting?
7.Types of Prompts Used? Ever used Tree prompt?
8.How to create Template?
9.How to create Portal tab?
10.Types of Variables?
11.Know what is Dispatcher in Cognos?
12.What are the Layout Components?
13.What is Render Variable?
14.What is meant by Macro? Any diff b/w Macro & Prompt?
15.How to schedule a report which has a prompt in it?
16.What is Primary key and candidate key?
17.Diff b/w Primary and Surrogate keys?
18.Dis-advantages of Value Prompt, if any?
19.What is DOLAP? where we use it?

SQL-Questions:
20.What is Inline query?
21.Diff b/w Delete, Truncate & Drop?
22.Diff b/w & and &&?
___________________________________________
Thanks Anu for attending the interview & noting down all of these questions.

Capgemini Cognos Interview Experience

Fellas,

The Capgemini interview was good. The questions follow.

DWH related:
What is Singleton?
Diff b/w Dimensional Modelling and Relational Modeling?
What is Star schema?

Cognos related:
How to Create a Portal tab?
How to create a Template?
How do you create Table of Contents?
What are the Types of Variables that can be created in Report Studio?
How to do Report Bursting?
Explain the Types of Securities in F.M.
____________________________________________
Thanks Anu for attending the interview & noting down all of these questions.