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

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 / suresh

1 Answers
4423 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.

2037

What is the difference between a standalone application, client-server application and web application?

1356

do we require any scripting languae to write test cases in test director? what for it is used?it is like back end?only database we can there?

2179

Which model is following in your company for developing software?

1226

Explain the strategy for testing a Java application?

2210

how to indentify memory leakages after the build

2193

Test cases have written according to Flow of the software working or according to Screens?

2006

1.what is the approach while writing test cases in your project. 2.tell some intresting scenareo in your project

2328

Why Equivalence Partitioning is called equivalence or what is the significance of equivalence term in ECP?

2187

In manual testing, what are stubs and drivers?

1184

Please Tell me About Fish-Bone Model. Thanks in Adv.

1972

ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience

1977

What is regression testing? When to apply it?

1197

what is difference between win 98 and win 2000 poertating system?which is better one?

2416

Should testing be done only after the build and execution phases are complete?

1685