?
Solved

Software ETL question

Posted on 2013-06-28
4
Medium Priority
?
619 Views
Last Modified: 2016-02-11
Hello Experts,

Which of these three different software’s extract, transfer and load data (Terabyte data) the quickest?  This data resides in Oracle.
      
1      ESSBASE  - Hyperion
2      Informatica
3      SQL - TOAD

Currently, using MS Access queries have proven very sluggish and slow, and we are wondering if SQL in Toad might be a potential solution.

What are your thoughts regarding whether or not ESSBASE, Informatica or creating Hyperion cubes would be an option of being faster with ETL?  

Thanks
0
Comment
Question by:CFMI
  • 2
4 Comments
 
LVL 18

Assisted Solution

by:sventhan
sventhan earned 1000 total points
ID: 39285139
I'd choose like this

1) informatica
2) ESSBASE
0
 
LVL 1

Author Comment

by:CFMI
ID: 39285431
My last two questions, can you explain why and does Informatica load data into SQL Server for Users to extract or does it stay within itself?
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1000 total points
ID: 39285474
Informatica, and other ETL tools such as IBM DataStage and Microsoft SSIS, are the tools to transfer data from a source to a destination.  

They are not data containers within themselves that store data.

>(Terabyte data)
>MS Access queries have proven very sluggish and slow
The file size limitation of an Access database is 2 Gb's, so if we're talking Teradata than that is well beyond Access' capabilities.
0
 
LVL 1

Author Closing Comment

by:CFMI
ID: 39285513
Thank you!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

599 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