Capgemni Interview Questions

How to create a PortalTab?
How to do Bursting a Report?
Explain Table of contents?
Diff b/w Dimensional modeling and Relational modeling?
Diff b/w Union and Unionall? What is Singleton?
What is StarShema? What is Inline Query? What is Surrogate Key?
Diff b/w surrogate Key and Primary Key?
What is Focalpoint?
What is Busschema?
What is Slicer memberset?
What is member Description?
What is Scopr Relationship?
What is Direct and Conventional loading?
Diff b/w MemberCaption and MemberDescription?
What is Determination Model? How to identify the Revenue Column in Report?

-------------------Cincomm Systems-------------------

Difference b/w OLTP and OLAP?
Compare OLTP and OLAP which will give the better performance?
What is the purpose of Dashboard?
Why we use Dashboards?
How to do performance tunning test in Cognos reports as well as how to do in Framework?

----------------Mind-Tree Questions--------------------

What is Rendervariable?
What are the Governer Settings?
Diff b/w Db view and bus view?
What is meant by Reportstudio Queryshortcut?
What is a Parametermap in FM?
Diff b/w Crossproduct and Outerjoin?
What is outerjoin?
What is Fullouterjoin?
What is Crossproduct?
What is Index?
What is Parllelquery Processing?
How to do Performance increase in Reportstudio?
Crosstab contains Producttype and Productname. I have grouped on Producttype after grouping also the cells should not be merged?
ListReport contains Producttype and productname. I have grouped on Producttype after grouping also the cells should not be merged?

Cognos-------All Interview Questions

-------Types of Prompts?
-------Types of Variables?
-------What are the advantages of Cascading Prompt?