Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46810 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
How can one identify whether mapping is correct or not without connecting session?
Make a note of the quantity vaults made in informatica?
what are the Methods For Creating Reusable Transformations?
Informatica settings are available in which file?
What is the maplet?
How to start a workflow using pmcmd command?
Differentiate between a database and data warehouse?
Briefly define a session task?
waht type of interface is used for testing the data in informatica
According to his methodology what all you need before you build a datawarehouse
What is difference between a gateway node and worker node?
What are batches?
How can we remove the duplicates from flat file source?
What is dynamic cache?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
