Dareware House Testing Observation

I got chance to do the Dataware house testing  (BI) in my company.

In Data Integrity testing, I have used below approach : 

I have used VBExcel comparer (Macro) to validate the column values or data between source and destination.
It is useful for me to validate/compare large number of records in both source and destination.
 

Few observations (Issues) found while doing the Performance testing,

While executing the ETL with huge volume of date, Out of Memory exception occurred. For BI Testing, mainly focused to avoid the memory related issues...

 After some extent of analysis to provide the solution that,

1. Release the the memory object through garbage collector after inserting the large volume of data. So Memory level has maintained at the same level if inserting huge data to the database.
2. Avoid to use more connection to open and close. Since every connection takes memory to initialization. So that is also taking some memory. Reduce the connections.

Note : I have used SQL Monitor 3.2 to analysis the performance of the server. It has been used generating various reports like CPU Usage, Disk Read, Disk Write, Disk Transfer, SQL Server Total Memory...etc.

softwaretestingcollege

http://www.softwaretestingcollege.blogspot.in/

Web Site Test Tools and Site Management Tools

http://www.softwareqatest.com/qatweb1.html#MOBILE

List of points to select Automation Tool

After the strong analysis and believe of automation will really help for our concern.However we have to choose a right automation tool to implement for our project requirement

Before choose the automation tool,think about the below points :

1.Do we need to automate standalone application or client/server application or both?
2.Are we ready to invest some money to buy a tool or not
3.Do we have the technical persons to train the resource or need any expert from out side
4.Is our existing testing resources capable of adopting the new technology?
5..How is the technical support available for the tool
6.How frequent update is available for the tool to handle the new technology implementation of AUT.
7.Complexity of using the tool.
 For Client/Server Application Selenium is my choice to automate my application for various reasons

• Its Free
• Its Compatible for many languages so i don't need a different language expert to implement. I can use any language which i am using to develop my application.
• Its easily maintainable during frequent integration

Test Data Generator

For all projects, test data is important for application testing (Validation). So i am looking for tool to generate test data.  Here i mentioned the link which i used to generate....
We can generate different type of test data  format like HTML XML, Excel, Csv, Sql

http://www.generatedata.com/#generator

softwaretestingclub

The below mentioned link to get more information about software testing...

http://www.softwaretestingclub.com

Checklist for Security Testing

1. Is confidentiality/user privacy protected?

2. Does the site prompt for user name and password?

3. Are there Digital Certificates, both at server and client?

4. Have you verified where encryption begins and ends?

5. Are concurrent log-on  permitted?

6. Does the application include time-outs due to inactivity?

7. Is bookmarking disabled on secure pages?

8. Does the key/lock display on status bar for insecure/secure pages?

9. Is Right Click, View, Source disabled?

10. Are you prevented from doing direct searches by editing content in the URL?

11. If using Digital Certificates, test the browser Cache by enrolling for the Certificate and completing all of the required security information. After completing the application and installation of the certificate, try using the <-- BackSpace key to see if that security information is still residing in Cache. If it is, then any user could walk up to the PC and access highly sensitive Digital Certificate security information.

12. Is there an alternative way to access secure pages for browsers under version 3.0, since SSL is not compatible with those browsers?

13. Do your users know when they are entering or leaving secure portions of your site?

14. Does your server lock out an individual who has tried to access your site multiple times with invalid login/password information?

15. Test both valid and invalid login names and passwords. Are they case sensitive? Is there a limit to how many tries that are allowed? Can it be bypassed by typing the URL to a page inside directly in the browser?

16. What happens when time out is exceeded? Are users still able to navigate through the site?

17. Relevant information is written to the log files and that the information is traceable.

18. In SSL verify that the encryption is done correctly and check the integrity of the information.

19. Scripting on the server is not possible to plan or edit scripts without authorisation.

20. Have you tested the impact of Secure Proxy Server?

21. Test should be done to ensure that the Load Balancing Server is taking the session information of Server A and pooling it to Server B when A goes down.

22. Have you verified the use of 128-bit Encryption?