i have soure and target having 1 laks records same structure and same data. no

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

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

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

Define the following and explain their usefulness: Change Management, Configuration Management, Version Control, and Defect Tracking.

2 Answers Ordain Solutions,

What r the document required for testing?

4 Answers

Give proper Seq. to following testing Types Regression, Retesting, Funtional, Sanity and Performance Testing.? and which phase of STLC comes?

1 Answers

What icon is used in WinRunner to get an explanation of the syntax of TSL?

0 Answers

what is the architecture for your project?

3 Answers

can any one explain the example of high servity and low priority, low servity and high priority, high servity and high priority, low servity and low priority

4 Answers Intact Solutions,

what is meant by adhoc testing?

9 Answers HCL, STC,

What is the difference between the test case and a test script

4 Answers

HI frnds, can any one tel me..when a tester can starts test case writing? reply sooooon plss..

5 Answers Polaris,

What is TestWare?

1 Answers

Who Prepare the Master Test Plan? Who Prepare the Test Plan?

1 Answers Patni,

what is the difference between test scenario n testcase.do we have separate template fr test scenario.what is the use of scenarios.pls explain with example.

4 Answers

For more Manual Testing Interview Questions Click Here