The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
132 views

How to do user acceptance testing on ETL/Data Warehouse

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 ...
2
votes
1answer
216 views

Testing database transformation mappings

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?
2
votes
1answer
479 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
4
votes
3answers
2k views

How far would you go in ETL and data warehouse testing?

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 ...
2
votes
3answers
2k views

What are some real world strategies for testing ETL and data warehouse applications

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 ...