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.

My Barclays Cognos Interview Experience

Hi all,

The following are the questions asked in Barclays Interview.

FM related:
1.What are the updations in 8.3 from 8.2?
2.How to give various types of security to FM Models/packages?
3.What is Dimensional Modeling?
4.What are the Governer settings?
5.What is Circular join?
6.Why shortcut is better than aliasing of Query Subjects in FM?
7.How to create IQD files?
8.Have you create Stored Procedure Query Subjects?
9.How to resolve Loops?

Report Studio:
1.Tell me about Migration Procesess?
2.Substantial differences in Reportstudio of v8.3?
3.What is Conditional Formatting and Conditonal layout?
4.Types of Prompts used?
5.What is Tree view prompt?
6.How to improve performance in a Report Studio report?
7. How to create a Union Report?
8.In Powerplay Transformer what are the various types of input?

As evident, these questions are the ones to test one's basic Cognos knokwledge.

Thanks Anu, for taking down all of this stuff.

My IFlex (Oracle Financial Services) Cognos Interview Experience

Hi all,

I have attended the telephonic interview with Iflex Solutions (Oracle Financial Services) on 28th August (Wednesday).
Mr Ganeshan was the interviewer. It went fine and almost all the questions are basic ones.

The following are the questions asked.

Cognos Framework Manager Questions:
1. What are Member Caption and Member Description?
2. What's the difference between Member Caption and Member Description?
3. What is Focal Point?
4. What is Slicer Member Set?
5. What is Scope relationship?
6. What are Determinants? Types of Determinants?

DB/DWH/SQL Questions:
1. What is a Pseudo Column?
2. How to display first & last records of any table?
3. What is Bus Schema?
4. What is Hybrid SCD?
5. What is Direct & Conventional Loading of Data?

My Niteo Cognos Interview Experience

Hi all,

I have attended the telephonic interview with Niteo on 27th August (Wednesday).
Mr Sudhakar and Ms. Poornima were the interviewers.
It went fine and almost all the questions are basic ones.
I am through to the second round which is a web cam interview.

Start of a long journey...

Hi,
This is a small(!) compilation of Questions i faced in my cognos interviews/i gather over the internet.
Any additions/corrections/mistakes can be intimated through comments section.
Hope this is helpful. :-)