please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
- 1 Answers
- 4971 Views
- Exilant, Wipro, I also Faced
- E-Mail Answers
star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
How we can add a comment in universe...?
What is the Drill filter and it's usage?
How many tables can an universe contain is their any limit to insert tables in the universe?
What are templates? Explain what you have created?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
Tell me about linked universe ?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
What is a Set?
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
Teradata 
