Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 47015 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 Active lock explain
explan ur project architecture?
tell me 5 session failure in real time how can you solve that in your project?
Explain the types of lookup transformation?
What's the layout of parameter file (what does a parameter file contain?)?
How do you load alternate records into different tables through mapping flow?
Explain scd type 3 through mapping.
Explian the Process of deployment groups in informatica
What is a stored procedure transformation?
Write the prerequisite tasks to achieve the session partition?
What is InformaticaPowerCenter?
Write the unconnected lookup syntax and how to return more than one column.
Separate from an archive server and a powerhouse?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is olap (on-line analytical processing?
