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.

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 is Difference between Test Strategy and Test Methodology?

1968


What are parametere require for Performance testing?

2113


sanity testing is done during regression testing.is it true.if it is true plz explain?

1663


how deployment phase of SDLC differs in product based and in service based company ?

2725


How to test the search functionality.For example in naukri advance search is there.how ca i test that page.

1934


Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.

1695


HI, This question is Investment Banking domain related Question. I was asked in an Interview to tell the 5 test cases for Equity,Bond,Futures and options. Please help.. Pragya

4168


Why is it impossible to test a program completely?

1191


write testcases for open dialogbox

1739


Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com

1919


what is API 2.0?

1777


How to test an application if it was already developed and it is in the state of changing the functionality according to the customer requirement How to start testing in this situation. I got an application to test.It is a desktop application.It is still developing and started 8 months back.how can i start to test this application? Is it the right way to test it in "Random testing"? or writing the testcases from page one and executing them.i have an another responsibility that is I have to automate that application. can anyone tell me what is the process to test this application.

1785


Do we have any certifications for ETL Testing ?

1931


How do test documents in a project span across the software development lifecycle?

1380


Tell me the advantage and disadvantage of cookies?

996