Question
In database testing, how to do the data load testing?
Answers
For data load testing:

You need to have knowledge about source database (data tables, columns, associated constraints, data types) and destination database (data tables, columns, data types, and constraints).
You need to check the compatibility between source database and destination database via the DTS package.
You need to Open corresponding DTS package in SQL Enterprise Manager and run the DTS package (If you are using SQL Server).
Then you need to compare the column’s data of Source and the Target.
You have to check the number to rows of Source and Target.
After updating data in the Source database, you need to check whether the changes have been reflected on destination database or not.
You need to check about junk character and NULLs.
Database load testing, check the volume of the database server to process the queries, and also check the response time of database server and client.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Who was the first black entertainer to win an Emmy award
  • Q In which player name, Fastest fifty in a T20?
  • Q What is more important to you: the money or the work?
  • Q The most abundant element in the earth crust is:
  • Q what is the model to interprete data ?
  • Q What is the difference between prefix and postfix versions of operator++()?
  • Q What is deployment environments?
  • Q With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
  • Q The new institution which replaced the earstwhile planning Commission in India?
  • Q Is double-clicking supported on various components?
  • Q In which region of India desert is situated: