Answer Posted / m m naidu
surrogate key: It has system generated artificial key
values, which allows to maintain historical records in the
data warehouse more effectively.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain what is the difference between native sql and cognos sql?
How create measures and dimensions?
can we insert all types of charts in a list report? what r the realtime prompts?
What is the importance of having monitor service in cognos?
What do you understand by user class in cognos?
4. How many dimensions did you use in your reports?
What errors and types of errors you faced in Cognos ReportNet?
What are the methods by which it non-durable model could be changed into the durable model?
how you provide security to reports? How you provide security to packages ?
Why need staging area database for dwh?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are the types of folder present in cognos?
--------------Diff b/w ODS and OLAP?
What are the different uses of a repository manager?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these