Difference between online Analytical Processing Tool and ETL tool

Asked By wexler huddard 10 points N/A Posted on - 04/07/2012

Dear friends

What are the various ETL and Online Analytical Processing Tool?

Differences between ETL Tools and OLAP Tools.

Thanks

• Status: Open
• Question Views: 1820
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: OLAP

Best Answer by Sharath Reddy

Go To Solution

Answered By Gado Cheryl 95 points N/A #107999

Difference between online Analytical Processing Tool and ETL tool

Various ETL tools you can find in the market.

They are Informatica
Data Stage
Oracle Warehouse Builder
Ab Initio
Data Junction etc.

Also you can find OLAP tools. Visit the site for instance: https://searchdatamanagement.techtarget.com/definition/OLAP

Before I discuss something about the difference between ETL tools and OLAP tool, I wish you know that ETL means extract, transform, load and OLAP means online analytical processing.

This two is work for each other. So it’s going to be interesting to point out the difference between the both. ETL is basically a process of extract, transform and load data into a preferred meaningful form. And also aggregate the data. This data make usable for the OLAP tool. It can visualized the data into a different from. ETL tools is also use of to fulfill the cleaning data. OLAP tool use the help of a query to extract data from the selected database.

If you learn more about ETL and OLAP, then you will be more understand the difference between the both.

About Gado Cheryl

Questions
1

Answers
191

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 05/09/2012
• Question Category: OLAP

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #108000

Difference between online Analytical Processing Tool and ETL tool

ETL stands for Extract, Transform, Load. These three are different database functions that are merged into one single tool which is the ETL tools. Its main function is to extract data from the database and then transfer it into another database. The extract function is the method of reading data from the database.

Transform is the method of converting the extracted data from its original form to the intended form so that it can be placed in another database. The transformation happens using lookup tables, mixing the data with another data, or using rules.

Finally, the load function is the method of writing data into the target database. So generally, the ETL tool is used to migrate or transfer data from one database to another to create data warehouses and data marts and additionally convert or transform databases from one type or format to another.

OLAP stands for Online Analytical Processing. This is a kind of tools that offers analysis of data saved in the database. It also allows users to examine various dimensions of multidimensional data.

This tool is frequently used in data mining.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 04/14/2013
• Question Category: OLAP

Answered By wexler huddard 10 points N/A #108001

Difference between online Analytical Processing Tool and ETL tool

By searching your comments, I got an idea; ETL is an extraction, transformation, loading tool i.e. I can extract, I can transform using different transformations accessible in the tool as well as aggregate the information. The output of this ETL tool is utilized as input to OLAP tool. OLAP is an online analytical process, where I can get online reports after doing some joining, creating some cubes, alongside much information which I had not realized before. Thanks mates, for upgrading my knowledge especially to Sharath for providing a clear and simple idea about the ETL and OLAP tool and Techyv too for endowing this post.

About wexler huddard

Questions
35

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/29/2013
• Question Category: OLAP