Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46520 Views
- I also Faced
- E-Mail Answers
Answer Posted / susanta karmakar
Star Schema: A star schema is a specialized design that
consists of multiple dimension tables, which describe
aspects of a business, and one fact table, which contains
the facts about the business.For example, if you have a
mail-order business selling books, some dimension tables are
customers, books, catalogs, and fiscal years. The fact table
contains information about the books that are ordered from
each catalog by each customer during the fiscal year.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
How to update a particular record in target with out running whole workflow?
What is different between the data warehouse and data mart?
Write the advantages of partitioning a session?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
can u any challenge your project?
Describe expression transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain Dataware house architecture .how data flow from intial to end?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain dynamic target flat file name generation in informatica
What is the fact table?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What do you mean by worklet?
what is the Default Source Option For Update Strategy Transformation?
