Solved

Software ETL question

Posted on 2013-06-28
4
596 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 18

Assisted Solution

by:sventhan
sventhan earned 250 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 250 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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