Does anyone have any advice to share on how to successfully test BIG ETL or data warehouse applications? I have my own iteas of course, but there only appears to be one main article on line that ...
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
Recently I've been testing on an ETL/Data warehouse project and the strategy I took was to work very closely with the business and leverage their knowledge to come up with all the weird and wonderful ...
If regularly testing the creation of different datawarehouse tables using mappings from source tables. What do you suggest is the best approach or specific SQLs to do the trick?