I am doing assessment of a present data warehouse.
I am shocked to see the design.
1. Logical data model and physical data model not in sync.
2. no keys between facts and dimension ie no star join.
3. No validation in ETL.
4. No exception handling in SQL procedures.
5. Views acts as fact tables.
Can we say this as datawarehouse.
I am shocked to see the design.
1. Logical data model and physical data model not in sync.
2. no keys between facts and dimension ie no star join.
3. No validation in ETL.
4. No exception handling in SQL procedures.
5. Views acts as fact tables.
Can we say this as datawarehouse.