183 ) Data modeling excel questions

 

Fact Tables & Data Warehousing

------------------------------------------------------

1. Why do we need Data Warehouse
2. Enterprise data modeling - Insurance project OLTP
3. Types of data models 
4. star or snowflake schemas ( how to chose)
5. Types of facts and dimensions
6. OLTP & OLAP diff
7. SCD types and implementation
8. Experience in Metadata management MDM
9. Data dictionary✅
10. STTM 
11.  181 ) How to handle volume - Dimensional Data Warehouse -
12. 182 ) why we need OLAP when we can query with OLTP
13.  184 ) How to merge, add, or delete columns or add new dimensions  in data model  Later
14. 134 ) Types of indexes 
15. 212 What is Medallion Architecture?
16. 211 ) How do you calculate the size of each table
17. 210 Did you work on NOSQL database
18. 209 Views and materialized views
19. 208 ) roles of data architect and responsibilities
20. 207 What are roles of data modeler
21. 205 ) What are ACID Properties?
22. 204 ) Which tools used for Data profiling tools ...
23. 203 ) Normalization with Examples
1. CANONICAL MODEL
24. 202 ) what is use of Surrogate key is a
25. 201 ) OLAP & OLTP diff
26. 200 ) what is ODS( operational data store)
27. 199 ) Why do we need Data warehouse, when OLTP app...
28. 198 ) What is Data Mart
29. 197) Types of Dimensions
30. 196 ) star and snowflake
31. 195 ) logical data model vs. physical data model diff
32. 194 ) Grain and granularity
33. 193 ) Types of Fact tables amnd facts
34. 192 ) Ralph kimball & inmon approaches
35. 191 )How to add a completely new metric to an exi...
36. 190 ) How do you handle missing or unknown Dimensi...
37. 189 ) How do you deal with duplicate records into ...
38. 188 ) Additive, Semi-Additive, and Non-Additive Fact?
39. 187 ) How to handle (Slowly Changing Dimensions)
40. 186 ) Late arriving dims & factless fact tables
41. 185 ) How to ingest fact table a weekly, monthly...

-------------------