Series: Subject: Topic:
Question: 88 of 307

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

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.

Answered On : Jul 23rd, 2009

View all answers by MalaiPan

Loading PerformanceError rateProcess Restart & recovery pointCleansingStatistics on how many row extracted, how many left in each staging and how many loaded into target data warehouse.

Login to rate this answer.

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



twitter fb Linkedin GPlus RSS


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.