My question is regarding Back end testing. How can i validate the data in the table which consists of million rows in a table without using any automated tools . I have validated the tables before using simple SQL statements(Like SELECT statements)but have no idea on validating million rows. Data is received from different sources and is transformed to oracle db through ETL(Extract Transform Load).Can someone help me regarding what SQL statements are used to validate the data. I have an interview on this tomorrow and have no idea about their business requirements.
Odds are you won't know much detail about the business requirements until you get to the interview. Can you draw on your knowledge of generic requirements that generally apply across the board to this type of testing?
As I asked in the other forum that I saw this same question in, what does this have to do with WinRunner?
Beyond that, you will probably want to spend some time in some online datawarehouse forums. That's really what you'll be testing.
And I will give you this much of a hint: If you want to test the ETL process, you will need to find some mechanism to compare your source data (the extracted data) against your destination data (the transformed and loaded data).