Tag Info

Hot answers tagged

3

I agree there's not much out there - I took on my first (and so far, last) data warehouse testing project a couple of years ago and found it pretty hard to find good advice. I haven't responded so far, as I think my experience having done just one project is fairly slight so I was waiting to see if you got more useful responses. Some good resources: Karen ...


1

[Disclaimer: This product is created by my company] We have a product call QuerySurge that allows you to fully compare data in the source tables with the data loaded into the data warehouse. Compared to other approaches, this seems to be the best automated method for validation.


1

Updating to reflect exit criteria for testing. You can look at MSDN article - Adventures with Testing BI/DW Application:On a crusade to find the Holy Grail - http://msdn.microsoft.com/en-us/library/gg248101.aspx Critical areas to focus are Validating the ETL Scenarios for full, delta pull Testing with Production Data for multiple regions, multiple data ...


1

It is not possible to do exhaustive testing in the context of data warehousing. I had been into ETL testing. There was a corner case bug in which if there is a lock created on one of the tables in the source database, the migration of data to the destination DB failed. Is it possible for any tester to imagine a scenario where table gets locked automatically ...


1

Starts the project with run the jobs manually. check all the source data is loaded into target or not. Write Sql queries to compare source and target data. review the column mapping document. check surrogate key is generating unique value or not. check surrogate key value is not null. chcek primary key value is not null. check the count of source and target ...



Only top voted, non community-wiki answers of a minimum length are eligible