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 ...
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
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?
I've tried running searches on Google, however there is not a lot of information available on testing ETL and DW solutions. I'm specifically interested in functional/user acceptance testing. The only ...