Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

ETL Testing coverage

3 posters

Go down

ETL Testing coverage  Empty ETL Testing coverage

Post  Henar Safwat 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

Back to top Go down

ETL Testing coverage  Empty Re: ETL Testing coverage

Post  BoxesAndLines Wed Sep 02, 2015 7:12 pm

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

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

Back to top Go down

ETL Testing coverage  Empty Complex data mapping

Post  Henar Safwat 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

Back to top Go down

ETL Testing coverage  Empty ETL Testing coverage

Post  zoom 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

Back to top Go down

ETL Testing coverage  Empty Re: ETL Testing coverage

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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