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
4362 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

what are all the possible Test Cases for VoIP based applications

1770

Hello again!! wanted to ask you HOW EXACTLY create stubs and driver in integration testing? 2.whats the difference between integration testing and system integration testing? Thanks!!

2183

How we can test Cookies Manually?

2201

Explain unit testing, integration tests, system testing and acceptance testing?

1283

Explain the difference between severity and priority.

1154

Explain the difference between alpha testing and beta testing.

1114

What will be the QA roles and responsibilities in Health care stream like BCBS,can someone please explain me any example project regarding health care services in web-based application?

2218

What is the main use of preparing traceability matrix and explain the real time usage?

1236

Explain thread testing.

1081

What is a code walk through?

1131

How do you scope out the size of the testing effort?

2374

What are bug leakage and bug release?

1262

What is quality center? What are the modules of quality center?

1104

i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.

5665

user id @ yahoo.com (or) yahoo.co.in (or) gmail.com.... etc

2401