Thursday, 15 November 2012
Monday, 3 September 2012
Example of ETL Testing
For example, you're testing an ETL
job/process/whatever with a minimal set of records (define that however you
like)...and the 'real' ETL job/process/whatever is going to be expected to
handle a significantly larger set of data, you may want to think about generating
additional data to get to the size of what you will be seeing in your
production environment.
Additionally, you may want to think about what the volume of data pre-existing in your production environment is going to be when you do the above-mentioned test (in your test environment.)
We're looking at two different overall tests above:
1. How long will it take to process a production size file?
2. A variation of 1. How long will it take to process a production size file with a production size database?
Part of the question that you will want to think about is how long does it take for the ETL job/process to complete. The source of this question is that you may be negatively impacting the user experience (that is, if you have some sort of user application that uses the data that you just loaded.) If you have an ETL job that runs for hours and gobbles up resources, that's not good.
Additionally, you may want to think about what the volume of data pre-existing in your production environment is going to be when you do the above-mentioned test (in your test environment.)
We're looking at two different overall tests above:
1. How long will it take to process a production size file?
2. A variation of 1. How long will it take to process a production size file with a production size database?
Part of the question that you will want to think about is how long does it take for the ETL job/process to complete. The source of this question is that you may be negatively impacting the user experience (that is, if you have some sort of user application that uses the data that you just loaded.) If you have an ETL job that runs for hours and gobbles up resources, that's not good.
ETL TESTING
ETL stands for extract, transform, and load. It
can consolidate the scattered data for any
organization while working with different departments. It can very well handle the data
coming from different departments.
organization while working with different departments. It can very well handle the data
coming from different departments.
Thursday, 9 August 2012
Problems in downloading Microsoft Script Debugger along with QTP installation
Problems in downloading Microsoft Script Debugger along with QTP installation:
Sometimes we will face a strange problem while installing QTP 9.5 / 10, Microsoft script debugger will fail during installation. In this case we are not able debug either actions or function libraries.
How to fix this issue.
1. You can run the Additional Installation Requirements utility at any time by choosing Start > Programs > QuickTest Professional > Tools > Additional Installation Requirements.
2. Install the same i.e. "scd10en.exe" from any internet site orhttp://www.microsoft.com/downloads/details.aspx?FamilyID=2f465be0-94fd-4569-b3c4-dffdf19ccd99&DisplayLang=en
How to fix this issue.
1. You can run the Additional Installation Requirements utility at any time by choosing Start > Programs > QuickTest Professional > Tools > Additional Installation Requirements.
2. Install the same i.e. "scd10en.exe" from any internet site orhttp://www.microsoft.com/downloads/details.aspx?FamilyID=2f465be0-94fd-4569-b3c4-dffdf19ccd99&DisplayLang=en
Subscribe to:
Posts (Atom)