GeekInterview.com
Series: Subject: Topic:
Question: 85 of 304

What are the things to consider while testing ETL ?

Asked by: ETLguru | Member Since Nov-2007 | Asked on: Nov 1st, 2007

View all questions by ETLguru

Showing Answers 1 - 3 of 3 Answers
mrahman

Answered On : Feb 23rd, 2008

View all answers 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. 

 

Yes  1 User has rated as useful.
  
Login to rate this answer.
MalaiPan

Answered On : Jul 23rd, 2009

View all answers by MalaiPan

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.

  
Login to rate this answer.
saravanan123

Answered On : Aug 18th, 2009

View all answers by saravanan123

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

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.