All Questions
Tagged with data-warehouse-testing sql
2 questions
1
vote
0
answers
24
views
How to properly validate an ETL process?
In an ETL process a table is dynamically constructed using a complex SQL query. This query is written by a developer. As a QA engineer, how can I validate that the table is correct according to ...
- 11
5
votes
2
answers
2k
views
Data warehouse testing checklist
What are some best practice approaches such as:
SCD type 1/2/3
nulls
duplicates
missing data
extra data
special characters
FK/PK referential integrity.etc
- 211