ThisisRaj

 Profile Answers by ThisisRaj 

• Mar 8th, 2009

 

You can do that by comparing the source vs warehouse tables in SQL Server you can use like this

source.table1
except
warehouse.table1
Union
Warehouse.table
except
source.table1

Why do you do the above union is you are taking source table as the base table and compare with warehouse then take the warehouse as source and compare that with source table then you get the differences.

anita_09

 Profile Answers by anita_09 

• Sep 10th, 2009

 

ETL testing validates that data is transformed correctly from OLTP to data
warehouse.

Validating the data transformed includes following main verification points:

1. Ensures that all expected data is loaded. Comparing record counts between
   source data, data loaded to the warehouse and rejected records.


2. Ensures that all data is transformed correctly according to design
   specifications.


3. Ensures that the ETL application substitutes default values, ignores
   invalid data.


4. Validate correct processing of ETL-generated fields such as surrogate
   keys.


5. Validate that data types in the warehouse are as specified in the design
   and/or the data model.


6. Validate the referential integrity between tables.

wyaddow

 Profile Answers by wyaddow 

• Jan 22nd, 2010

 

As far as my knowledge we do not have any ETL Testing Certifications.