Data Warehouse performance test

sumisu

DW Fresher

Reputation: +1/-0
Offline

Offline

Posts: 1

Data Warehouse performance test

« on: October 31, 2009, 02:43:54 am »

Hi,

First of all, sorry for my poor English.
I’m doing an internship as part of my Bussiness Information Systems study. My Job is to exermine the possibilities of using open source Data Warehouse Systems for Data Warehousing as a Service solutions. The main focus is on the performance aspects.
Is there any best practice for Data Warehouse performance testing (benchmarking)? And are there any tools for Data Warehouse performance testing?

Thanks in advance!


	Logged

Arvind

DW Apprentice

Reputation: +10/-0
Offline

Offline

Posts: 78

Re: Data Warehouse performance test

« Reply #1 on: November 06, 2009, 09:00:58 am »

Quote from: sumisu on October 31, 2009, 02:43:54 am

And are there any tools for Data Warehouse performance testing?

In my experience I haven't observed any specific tool that too exclusively for Data warehousing performance testing. But where as ETL tools will allow us to progress with performance testing while coding is in progress.
For each of ETL tools, they do have their own best practices for Data Warehouse performance testing.

For Informatica ETL Tool, there's a complete document for performance Testing and Tuning. Hope this all gives you a clarity. Grin


	Logged

regards,
Arvind

melina386

DW Fresher

Reputation: +1/-3
Offline

Offline

Posts: 7

Re: Data Warehouse performance test

« Reply #2 on: November 16, 2009, 11:27:08 am »

I guess u can go for the loadrunner. If you know other alternative tool please do reply me.
Related White Papers and Webcasts

   * Red Hat Enterprise Linux Leads the Way with Web Applications
   * Oracle Real Application Testing 11g Release 2
   * The Science of Web Load Testing

Moderator - As per DW Forum Rules