I am currently pursuing a career in Cognos and need your
support in the same regard. I am in the position that you
were in as described above. I would like you to share your
experience during interviews, project explanation, on the
job etc. I am preparing for the interviews and am quite
nervous about cracking it. I am sure you understand the
anxiety. Your help will be greatly appreciated.
Awaiting your response!
- 3 Answers
- 8480 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shweta
Hi, I am also preparing for the interview.
Interviewers are more interested in the project explanation.
So along with the concepts, prepare your project well. All
the details about it. The interview questions that are
posted here are also very useful. I wud recommend you to
prepare all these questions well.
Take care and all the best.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
u dont worry first u preapre well datawarehouse concepts
then cognos subejct ok if u have any doubts call me thnak u
09769366443
satish.ch
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / xxx
What is normalisation?
What is a trigger? (A special type of stored procedure, executed when certain event occurs.)
What does the FROM clause do?
Can you use an UPDATE clause and a SELECT clause together in the same query?
What is the difference between unique key and primary key?
What is referential integrity?
What is the use of AS clause?
What does locking refer to?
Why ORDER BY clause is used?
What is clustered and non-clustered index?
What is the difference between DELETE, DROP and TRUNCATE?(Delete-deletes the rows based on WHERE clause, Drop-Delete the table structure, Truncate-Deletes all the rows in a table without affecting the table structure)
| Is This Answer Correct ? | 1 Yes | 0 No |
6. Which of them will increase the performance?
What is stitched Query?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
How to improve the performance of the report at the report level?
What is metric store database?
------------ Diff b/w MemberCaption and MemberDescription?
What are all the advantages of Cognos?
What are the types of studio?
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
what is the use of macros&folders&herarchies in frameworkmanger?
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
3. What was the size of your cube?
Teradata 
