when can i use the STAR Schema and SNOWFLAKE Scgena
Answer Posted / khushbu
snowflake is normalized model there for it require less storage space.
but star schema is not normalized. it has redundant data therefore require more storage.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Give me any example of semi and non additive measures?
Can you define dimension?
9. What was the most complex type of report you dealt with?
Why is auto-regression used in forecasting used on cognos platform?
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 dtm?
what is hints in cognos and where we use it.
How create measures and dimensions?
What are the two types of framework manager?
What is model filter?
What are all the components of Report Studio?
what is the difference between list report and crosstab report?
What is the difference between low affinity and high affinity connections?
What is the use of report studio?
Define report item?