which type of project we r going to snowflake schema
Answer / Akash Yadav
In Cognos, a Snowflake Schema is typically used for data warehousing projects. It's a star-like schema where the central fact table has pointers that point out to multiple dimension tables (like a snowflake). This schema design helps in efficient querying and analysis by reducing join operations.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you define pivot?
can you apply grouping on crosstab?
5. Which type of report you build more, list, crosstab or chart and why?
what are the types of scheduling and what are the errors faced while scheduling then how to solve those errors?
1 Answers Dr Reddys, TCS, Thomson Reuters,
What is the difference between the standard and metrics folder?
What is the difference between low affinity and high affinity connections?
What is difference between drill through and drill down?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
what is dynamic sort?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
difference between join and union in reportstudio?
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex: