Interview Questions 202
上一篇 /
下一篇 2010-06-23 15:14:30
/ 个人分类：Interview Questions
(ETL is a tool made by two companies ‘AbInitio’ and ‘Informatica’) ETL now processes the job to create a file (output file) to produce the report. The file is now displayed in the GUI Front End report with the help of Business Object (or Crystal Reports. These are tools that display data in GUI format). In the GUI Front End report, let us say, if for January, the deposit of that person was displayed as $ 900.00. Then my job was to validate whether this $900 is correct or not. I validated this data by writing SQL queries directly to the database. The data pulled from my SQL query should match to the data in the GUI front end. In other words, my SQL query should also display $900. If it matches, it is well and good. If it doesn’t, then it’s a bug. This is how I have done my Back End Testing.
How can you be sure that the query you wrote is correct? Or how do you know that the data you pulled from the database is correct?
Answer: I write SQL query based on the requirement document. In the requirement document, various conditions are given for the query. Based on those conditions, I write SQL query. Therefore, anything different from the requirement document is definitely a defect.
收藏
举报
TAG:
