ETL Testing coverage

View previous topic View next topic Go down

ETL Testing coverage

Post  Henar Safwat on Wed Sep 02, 2015 6:49 pm

i'm working on a testing project for ETL ,and i need to be sure that my test cases covered most of the issues in the project.Is there anyway to check this.

Henar Safwat

Posts : 8
Join date : 2013-02-06

View user profile

Back to top Go down

Re: ETL Testing coverage

Post  BoxesAndLines on Wed Sep 02, 2015 7:12 pm

You have a source to target mapping specification? If yes, test that.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Complex data mapping

Post  Henar Safwat on Sun Sep 06, 2015 12:14 am

thanks for your replay ,
i'm a little confused about the cases when the column in the destination table come from complex query (multiple joins between tables) from the source DB .i.e in the case that employee name is stored in the contact table that have foreign key with the employee table so what will be the situation in the mapping document ?? (the Employee name in the Employee Dim cann't be mapped to the contact Name in the Contact table in the source DB)


Henar Safwat

Posts : 8
Join date : 2013-02-06

View user profile

Back to top Go down

ETL Testing coverage

Post  zoom on Sun Sep 06, 2015 11:47 am

Here are some of the test cases:

1) Test data is loaded correctly and it is conformed to the specification.
2) If data is coming from different DB, then unload source data into a file and also unload target data ( from data warehouse or ODS) into a file. Open those files into MS Access and do the data comparison and validation.
3) There should be unique index on the business keys in data warehouse or in ODS. Any data load reject should be researched or tested based on the unique business key..
4) If source data does not have all the test scenarios to test ETL process, then use existing data and updated it as per the test scenario. For example is client name must not be null and you want to test it then updated a record and make a client name null and load that data to test ETL.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: ETL Testing coverage

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum