Posts

Showing posts from October, 2012

DW Testing - Test Ideas

DW Testing - Test Ideas Data Completeness Is all expected data being loaded? Is your DW handling updates over time? Is delta pull being tested other than full? What happens when error occurs during the ETL process? Is application able to recover after error? Does the ETL have the ability to resume from the point of failure? Are all data source being considered for testing? Is row count from source to target as per the requirements? Is there any extra data present in the target system? Is unique values of key fields between source data and target data same? Is data truncating before putting into datawarehouse? For example - Source Column width might be having 30 characters, whereas destination might have only 20. Is boundaries of each field been tested? For example, for a decimal(3) field include values of -99 and 999, and for date fields include the entire range of dates expected. Data Transformation Is all data being transformed correctly accordingly to business