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 difference between regression and retesting? urgent

8 Answers   iSoft,


What are the limitations for testing?

4 Answers   Thatavarti Technologies,


How Requirement is linked with traceability matrix. Give proper example

1 Answers  


What is the difference between alpha and beta testing

13 Answers  


What is testing process

8 Answers   IBM,


How you will test pen

6 Answers   Accenture, Digital Mesh,


If you stuck somewhere while reproducing defect then what will you do?

3 Answers   CybAge,


Diffrence b/w functional testing,functionality testing,system testing?

1 Answers   CIL,


Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position

1 Answers  


How does one do Ad-hoc Testing?

5 Answers  


Identify correct statement

1 Answers  


how do u develop test harness?

5 Answers   Semantic Space,


Categories