Interested to Buy Any Domain ? << Click Here >> for more details...
What snowflake and Starschema?
- 2 Answers
- 6184 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bhaskar.nagi
Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.
Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srini madhala
Star Schema:In Star shema we have fact table sorrounded by
diemension table.Since the shape looks as a star its called
as star schema
Snow Flake Schema:
in Snow flake schema we have fact table sorrounded by
diemension table and the diemensional table have their child
diemensions.Its denormalized
| Is This Answer Correct ? | 3 Yes | 2 No |
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
write a query to display to 10 max record from the employee table?
Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code
Can you define pivot?
Define query items?
How to select multiple values from type-in prompt?
Why need staging area database for dwh?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
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.
which difficult you faced in your project?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
Teradata 
