Test Cases - What are the things to consider while testing ETL ?

GeekInterview.com > Interview Questions > Testing > Test Cases

Go To First | Previous Question | Next Question

Test Cases | Question 219 of 269

What are the things to consider while testing ETL ?

Total Answers and Comments: 3

Last Update: August 18, 2009 Asked by: ETLguru

Sponsored Links

Best Rated Answer

—

Submitted by: mrahman

the process of Testing the web based application and ETL application is quit diffrent.the major difference is in web based application we test the GUI part of the applicaytion as well as the main functional tesitng.but as it in ETL first

we have to understand the source structure like ,how many records are comming from source and how many records are loaded in to the target this is the basic motivation for testing the ETL. then how many records are rejecting and waht is the reason for rejecting.

second,we have to test the Back-end data driven test.

we have to test ETL components by execuitng SQL,PL/SQL queyries.

we have to test the mapping naming convertion is done with respect to SRS.

Above answer was rated as good by the following members:
sohitbon

February 23, 2008 01:47:41

mrahman

Member Since: May 2006 Contribution: 3

RE: What are the things to consider while testing ETL ?

the process of Testing the web based application and ETL application is quit diffrent.the major difference is in web based application we test the GUI part of the applicaytion as well as the main functional tesitng.but as it in ETL first

we have to understand the source structure like how many records are comming from source and how many records are loaded in to the target this is the basic motivation for testing the ETL. then how many records are rejecting and waht is the reason for rejecting.

second we have to test the Back-end data driven test.

we have to test ETL components by execuitng SQL PL/SQL queyries.

we have to test the mapping naming convertion is done with respect to SRS.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 23, 2009 20:22:52

MalaiPan

Member Since: July 2009 Contribution: 1

RE: What are the things to consider while testing ETL ?

Loading Performance
Error rate
Process Restart & recovery point
Cleansing
Statistics on how many row extracted how many left in each staging and how many loaded into target data warehouse.

Is this answer useful? Yes | No

August 18, 2009 08:59:23

saravanan123

Member Since: July 2009 Contribution: 163

RE: What are the things to consider while testing ETL ?

Things to be considered :

1.Check we can get any the existing data`s
2.Check we can clean up the data`s
3.Check we can add new many datas
4.Check we can merge many data`s
5.Check for the limitation of the data`s
6.Check for the security purpose of using data`s
7.Check whether it is overlimited how much time we needed to get from the extaction

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank