Solved

performance testing in Data Warehouse

Posted on 2009-04-01
3
859 Views
Last Modified: 2012-05-06
Hi all can any one give me some knowledge  and real time scenarios for Database perfomance testing at data ware house level
0
Comment
Question by:kothapet
3 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 250 total points
Comment Utility
Possibly you have to test:

1. A stand alone table schema with a SQL ETL load process for complete data refreshes

2. A Materialized view schema with Complete (reload from Scratch) refreshes

3. A materialized view schema with Fast (incremental) refreshes

Methodology here:

https://gforge.nci.nih.gov/docman/view.php/369/13665/MDR_Warehouse_Perf_Testing_Report_v3.doc
0
 
LVL 9

Assisted Solution

by:Suveer Patil
Suveer Patil earned 250 total points
Comment Utility
You can check out the below link, i hope this will be definitely useful to you
http://www.information-management.com/issues/20070601/1086005-1.html
http://www.rttsweb.com/platforms/datawarehouse/
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now