Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46717 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
What is domain in terms of informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What's the layout of parameter file (what does a parameter file contain?)?
What is a grid in Informatica?
Explain how many types of dimensions are available in informatica?
Why update strategy and union transformations are active?
What is the use of an aggregator cache file?
What will be the approach?
How to convert multiple rows to single row (multiple columns) in informatica
What is the command used to run a batch?
What is a pre-defined event and user-defined event?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to Create a folder using pmrep command?
What is persistent lookup cache?
How can we update a record in the target table without using update strategy?
