What Is The Difference Between Etl Tool And Olap Tools?

1.	What Is The Difference Between Etl Tool And Olap Tools?
Answer» ETL tool is meant for extraction data from the legacy systems and LOAD into specified database with some process of CLEANSING data. ex: Informatica, data STAGE ....etc OLAP is meant for Reporting purpose in OLAP data AVAILABLE in Multidirectional model. so that you can WRITE simple query to extract data from the data base. ex: Business objects, Cognos....etc ETL tool is meant for extraction data from the legacy systems and load into specified database with some process of cleansing data. ex: Informatica, data stage ....etc OLAP is meant for Reporting purpose in OLAP data available in Multidirectional model. so that you can write simple query to extract data from the data base. ex: Business objects, Cognos....etc

Answer»

ETL tool is meant for extraction data from the legacy systems and LOAD into specified database with some process of CLEANSING data.

ex: Informatica, data STAGE ....etc

OLAP is meant for Reporting purpose in OLAP data AVAILABLE in Multidirectional model. so that you can WRITE simple query to extract data from the data base.

ex: Business objects, Cognos....etc

ETL tool is meant for extraction data from the legacy systems and load into specified database with some process of cleansing data.

ex: Informatica, data stage ....etc

OLAP is meant for Reporting purpose in OLAP data available in Multidirectional model. so that you can write simple query to extract data from the data base.

ex: Business objects, Cognos....etc

Discussion

No Comment Found

Related InterviewSolutions

Techniques Of Error Handling - Ignore , Rejecting Bad Records To A Flat File , Loading The Records And Reviewing Them (default Values)?
What Is The Difference Between Joiner And Lookup?
What Are The Various Test Procedures Used To Check Whether The Data Is Loaded In The Backend, Performance Of The Mapping, And Quality Of The Data Loaded In Informatica?
Where Do We Use Connected And Un Connected Lookups?
What Is The Difference Between Informatica 7.0&8.0?
How Can I Edit The Xml Target, Are There Anyways Apart From The Editing The Xsd File. Can I Directly Edit The Xml Directly In Informatica Designer?
What Is Conformed Fact? What Are Conformed Dimensions Used For?
Define Non-additive Facts?
What Is Data Purging?
What Are The Different Problems That Data Mining Can Slove?