Answer Posted / amp mohan
StarSchema: It is a logical database implement physically
in the datawarehouse with centralized fact table
normalized, depends on the denormalized dimension
table.Advantages of starschema is slicing down,performance
increase and easy to understand the data.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
------------------What is Inline Query?
What is a Query Subject?
What is defined as Query studio?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Explain the different types of views used in cognos.
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is model filter?
What is set to be cardinality?
Name the types of report?
What do you mean by query studio?
Can you define a catalog and types of catalogs in cognos?
Can you define cognos impromptu?
How to publish a package by running Java Script?
How create measures and demensions?
What is a Datastore in Cognos?