What is Star Schema?
- 1 Answers
- 1204 Views
- Informatica, I also Faced
- E-Mail Answers
Answer / Gaurav Goel
Star schema is a data model used for data warehousing, characterized by a central fact table surrounded by related dimension tables. The shape of the star resembles a point (fact table) and its connecting lines (foreign keys) to multiple surrounding points (dimension tables).
| Is This Answer Correct ? | 0 Yes | 0 No |
Give me a broad concept of what a data warehouse is, and what it might be used for?
What are loops in Datawarehousing?
What is the working process for application.cfm?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is the metadata extension?
How to generate iqd file from framework manager?
How did you plan your Data ware house project?
How can we run the graph?
what is the difference between etl tool and olap tools
What is operational data source (ODS)?
What is Snow Flake Schema design in database?
What is the difference between view materialized view and view?
Teradata 
