1. Categories >> Software >> Testing >> Manual Testing
  2. Suggest New Category

i have soure and target having 1 laks records same structure
and same data. no primary key. how to do data validation in.
how to identify each and every record same r not. i want check
every record. wat is process.

Question Posted / sreenu


i have soure and target having 1 laks records same structure and same data. no primary key. how to..

Answer / suresh

By Using Minus query :
select * from Source
minus
select * from Target;

if it shows no rows found then their is no mismatch between
source and target.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

Give me some sertification courses in testing?

2 Answers  

What is diff b/n TRM(Test Responsibility Matrix) and RTM (requirement Tracebility matrix) or both are same??

5 Answers  

If you clink ok in the log in page, how will you get to know what is happening in the application? If any of you know the answer for this please post. Thanks

3 Answers  

a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh

0 Answers   TCS,

what is the need to write testcases??? cant u test ur application with SRS?? y u have to write testcase document??

4 Answers   FIC,




How and when a build can be assigned to a Tester and who do this responsibility? Is there any tool is used for performing this process?Generally what is the flow of "Build assignment"?

3 Answers   Bosch, HP,

11.what are two of your weaknesses?

1 Answers   Satyam, TCS, Tech Mahindra, VJIL Consulting,

suppose if you are in ATM center and if you withdraw an amount of rs. 10000/-, you get a message to your mobile for deduction of amount but you did not receive any amount from ATM machine. What will you do? How do you rise a defect?

3 Answers  

1)how the oppurtunities will be for a QA(manual1+yrs exp) in abroad? 2)how the chances wil be if i try to choose DEVELOPMENT side as my carrer using QA experience?

2 Answers  

Can you tell me what is boundary value analysis and Equivalence partitioning, and error guessing with examples

5 Answers  

hi.... plz tell me what all kinds of documents/reports are required for manual testing of a simple website(simple static pages). in a organization.

2 Answers   HCL, IBM, iPRO Solutions,

can we do iterative testing in v-model?

3 Answers  

For more Manual Testing Interview Questions Click Here
Categories