Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What's the industry standard for test data preparation for DW testing?

Status
Not open for further replies.

DWQAtester

IS-IT--Management
Oct 24, 2011
1
US
Hi,

Currently our team spent 20% - 35% of testing time to prepare test data for Data Warehousing project testing. I wonder is this % too high? what's the industry standard here?

Thanks!
 
At most of my engagements, there are one or more test regions in which the transaction systems generate test cases and test data, and we use these in DW testing. That is, we have a DW test environment which can be fed by the test transaction systems. If the project is DW internal, such as a new summary table or cube, then, again, the DW test environment can be used. If you use "live" data for testing, take care to insure compliance with respect to PCI, PII, HIPAA, and other regulated data elements.

The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top