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.