Interested to Buy Any Domain ? << Click Here >> for more details...
----------------Diff b/w Dimensional modeling and
Relational modeling?
- 2 Answers
- 14902 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answer Posted / pooja
Dimensional Model:
A denormalized relational model made up of tables with
attributes. Relationships defined by keys and foreign keys
Organized for understandability and ease of reporting rather
than update Queried and maintained by SQL or special purpose
management tools. Optimized for retrieval, the data
warehousing model.
Relational Model:
The Transaction Processing Model that Minimize data redundancy
since it is normalized.
Disclaimer: This posting is provided AS-IS with no
warranties or guarantees and confers no rights.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is the enterprise class platform architecture of cognos 8?
Can you explain a cognos controller?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
what is power prompt in cognos ep7series?what is the use of this?
what are the special features in cognos reportnet?
---------------Tell me about DWH Concepts?
What do you mean by Drill down and Drill Up?
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 are the services provided in cognos 8?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What do you understand by the term 'model durability'?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate how can we Upgrad the reports from version Impromptu 6.0
to 7.0 and Power Play from version 6.6 to 7.0 ? --------------Explain Table of contents?
