Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different types of schemas?
- 11 Answers
- 87635 Views
- ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / vignesh muralidharan
three types of schemas are availble.Star schema,star flake
schema & snow flake schema.
Star schema:It is highly denormalised,so we can retrieve
the data very fast.
Star flake schema:Only one dimension contain one level of
hierachy key.
Snow flake schema:It is highly normalised,so retrievel of
data is slow.
| Is This Answer Correct ? | 34 Yes | 43 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
How to extract sap data using informatica? What is abap? What are idocs?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a transaction control transformation?
Difference between Target-based loading and constraint-based loading?
Differentiate between a repository server and a powerhouse?
What is dimensional table? Explain the different dimensions.
What are the different types of transformation available in informatica.
How many dimensions are there in informatica?
what is mean by complex business rule ?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is expression transformation?
Explain the features of connected and unconnected lookup.
how to load dimension table and fact table. plz tell me the steps.
Is it possible to revert a global repository to local one and why?
