Fact Tables & Data Warehousing
------------------------------------------------------
- Why do we need Data Warehouse
- Enterprise data modeling - Insurance project OLTP
- Types of data models
- star or snowflake schemas ( how to chose)
- Types of facts and dimensions
- OLTP & OLAP diff
- SCD types and implementation
- Experience in Metadata management MDM
- Data dictionary✅
- STTM
- 210 Did you work on NOSQL database
- 209 Views and materialized views
- 208 ) roles of data architect and responsibilities
- 207 What are roles of data modeler
- 205 ) What are ACID Properties?
- 204 ) Which tools used for Data profiling tools ...
- 203 ) Normalization with EGS
- 202 ) what is use of Surrogate key is a
- 201 ) OLAP & OLTP diff
- 200 ) what is ODS( operational data store)
- 199 ) Why do we need Data warehouse, when OLTP app...
- 198 ) What is Data Mart
- 197) Types of Dimensions
- 196 ) star and snowflake
- 195 ) logical data model vs. physical data model diff
- 194 ) Grain and granularity
- 193 ) Types of Fact tables amnd facts
- 192 ) Ralph kimball & inmon approaches
- 191 )How to add a completely new metric to an exi...
- 190 ) How do you handle missing or unknown Dimensi...
- 189 ) How do you deal with duplicate records into ...
- 188 ) Additive, Semi-Additive, and Non-Additive Fact?
- 187 ) How to handle (Slowly Changing Dimensions)
- 186 ) Late arriving dims & factless fact tables
- 185 ) How to ingest fact table a weekly, monthly...
No comments:
Post a Comment