NEW INTERVIEW QUESTIONS.COM TESTING INTERVIEW QUESTIONS DATABASE TESTING INTERVIEW QUESTIONS DETAILS

Add to My Questions | Forward | Print

Question

How to test data loading in Data base testing

Answer

You have to do the following things while you are involving in Data Load testing. 1. You have know about source data (table(s), columns, datatypes and Contraints) 2. You have to know about Target data (table(s), columns, datatypes and Contraints) 3. You have to check the compatibility of Source and Target. 4. You have to Open corresponding DTS package in SQL Enterprise Manager and run the DTS package (If you are using SQL Server). 5. Then you should compare the column's data of Source and Target. 6. You have to check the number to rows of Source and Target. 7. Then you have to update the data in Source and see the change is reflecting in Target or not. 8. You have to check about junk character and NULLs. IN DB Testing is to check all the datas are stored and retrived from the database properly. Answered By: Arumukam    Date: 4/9/2007 In Data Base Testing, basically all the events like Add, Delete, Update, Modify and some query etc... Answered By: Vijay Joshi    Date: 4/19/2007 just a small correction, ie insted of contraints it should be constraints Answered By: martin    Date: 9/1/2008 © NewInterviewQuestions.com

Answer:*
Name:*
Email Address:*
Verification Code	Not readable? Load New Code
Enter the above shown code:*

Category	DataBase Testing Interview Questions
Rating	(4.3) By 7 users
Added	8/13/2006
Views	153742
Rate it!	* * * * * * * * * * * * * * *
Free Offers:	300 Free Magazines for you. No credit card required. No Shipping Charges. Absolutely Free for 1 Year.

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email: