Explain and compare pros and cons of Snow Flake Schemas, and Start Schemas.
Posted On: Jun 15, 2021
Snowflake Schema is easier to maintain and change because of no redundancy and it is good to use for data warehouses with complex relationships. Whereas Star Schema has redundant data and hence difficult to maintain/change therefore it is good for Datamarts with simple relationships only.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Teradata Interview Questions
Explain Teradata utilities. What is MultiLoad , Fast Load, Tpump ?
Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time. FastLoad can sort the incoming rows directly into the target table. MultiLoad first...
Teradata Interview Questions
When do you use each of these? Why? Explain in detail.
It is used because Teradata utilities offer a powerful solution for managing all your data load requirements from batch to real-time....
Teradata Interview Questions
Explain Teradata Architecture in detail .
Teradata architecture is based on Massively Parallel Processing (MPP) architecture. The major components of Teradata are Parsing Engine, BYNET, and Access Module Processors (AMPs)....