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

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

what is stub and driver and tell me how can we introduce them in integration testing

3 Answers

what is test objective?

19 Answers CTS, Polaris, Value Labs,

1. why do you go for test bed ?

1 Answers

what is the diff b/w local and global variable?

1 Answers Verifone,

if u are asked to test yahoo login page what will be thw ur test cases ?

9 Answers Satyam,

how do u do smoke test for login page which has username , password, ok, and cancel buttons