Database Table comparison with SQL Query

Database Table comparison with SQL Query Demo[DTCSQL] : 

Sreelesh Kunnath Database Table comparison with SQL Query Demo[DTCSQL]

Content : 

Content QTP Automation Approach. Tool & Driver Setup. Global Environment variable and setup. Environment variable setup. Test Data preparation. Limitation of DTCSQL approach.

Automation approach: Table data comparison with SQL Query : 

Automation approach: Table data comparison with SQL Query As per DTCSQL(Database Table data comparison with SQL Query) approach, we can validate data using SQL query, this approach automatically  store mismatched data in the current working directory in the word format. Copy the _SetupVariable.ini file to following path C:\NetezzaData\.

Tool & Driver Setup : 

Tool & Driver Setup Install QTP 9.5. Install Netezza database driver and create DSN name for Netezza db. Save QTP script in the C:\netezzafolder\

: 

Update the Environment global variable in the _SetupVariable.ini file Following are Global variables 1) DBConnection 2) NetezzaDataFile 3) Netezzafolder 4) SQLcount 5) SQLQuery Update Environment variable

Environment variable setup : 

Environment variable setup Create  user Environment variable [Setup Variable = C:\NetezzaData\]

Test Data Setup : 

Test Data Setup Update the test data in the NetezzaDbData.xls [For Example: select * from (select * from customer_segmentation_period EXCEPT select * from customer_segmentaton_per) a limit 10,1]

Limitation of DTCSQL(Database Table data comparison with SQL Query) approach: : 

Limitation of DTCSQL(Database Table data comparison with SQL Query) approach: More than 1 lakh record may throw over flow error or memory leakage error in the word file. How we can resolve  leakage or overflow error in the word file:- If record range number less than 1 lakh  we can avoid memory leakage error or  over flow error Store record in the MS word range, using multiple MS word file we can avoid leakage or overflow error.

Test Execution time : 

Test Execution time Time taken for 100 mismatch record: Single record execution is 2.16% of 1 record =>.0216 sec For ‘N’ record execution is 2.16% of N=>N*2.16/100 Execution time for 100 record <=>100*2.16/100=>2.16 sec For watch Database Table comparison with SQL Query Demo movie.

Thanks for your time : 

Thank you Thanks for your time