when can i use the STAR Schema and SNOWFLAKE Scgena
Answer Posted / subbu
for huge amount of data snowflake schema is the best.and
for less amount of star schema is better
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Define catalog in cognos and write its various types?
9. What was the most complex type of report you dealt with?
What is a Transformer?
New coloums are added in database, then how you know in report level
Can you explain a cognos controller?
What do you understand by user class in cognos?
What is meant by alternate drill down with ex?
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 set to be Cognos configuration?
How to publish a package by running Java Script?
How can I test reports in cagonos?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
How can you link a query to a data container manually in Report Studio?
Can you define cognos decision stream?