Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 45344 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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a shortcut and copy in Informatica and how two are different with each other?
How are the sources and targets definitions imported in informatica designer?
What you know about transaction control transformation?
What is the session task and command task?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Which transformation is needed while using the Cobol sources as source definitions?
How to create Target definition for flat files?
How can we improve session performance in aggregator transformation?
difference between repository database and repository service?
What are the modules in Power Center
How does a rank transform differ from aggregator transform functions max and min?
Where are the source flat files kept before running the session?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain load alternative records / rows into multiple targets - informatica
