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
Can you explain the advantage of using shortcuts?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Explain the difference between native sql and cognos sql?
Define catalog in cognos and write its various types?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What is an olap designer?
Write some methods to apply securities in framework manager model?
How to deploy from one server to another server?
what is stitch query in reportnet?
How can I schedule reports in cognos?
hi my name is siraj i want to know cognos queriy language
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 is the difference b/w macros and prompt?
What is zero-foot print?
What are the components used in web tier?