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!
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 |
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
Where do you edit cognos sql in report studio?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
How to hide value prompt box and list when run report?
what are determinants?
how to perform back drill through in cognos 8 what is the use of it
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
which type of project we r going to snowflake schema