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.



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

What is the difference between Functional testing and Unit Functionality testing?

0 Answers   CSS,


Explain All-pairs testing?

1 Answers   CTS,


I need a Test case templetes for Yahoo Mail ID

1 Answers  


why did u choose software testing as ur profession????

6 Answers   AppLabs,


what is accessibility testing?

1 Answers   Sapient, Valtech,


What is Independant Testing? When and where this type of testing will be performed?

0 Answers   Satyam,


How can it be known when to stop testing?

3 Answers   IBM,


what is authorization & authentication?

2 Answers  


Tell me the advantage and disadvantage of cookies?

0 Answers  


what is a Checklist

2 Answers  


where do u store u'r Test cases?

5 Answers   Wipro,


What is the diffrence between Beta Testting & Acceptance Testing

6 Answers  


Categories