Differentiate Between Etl Tool And Olap Tool?

1.	Differentiate Between Etl Tool And Olap Tool?
Answer» ETL TOOL is used for extracting data from the legecy system and LOAD it into specified database with some PROCESSING of cleansing data. OLAP Tool is used for reporting process . Here data is available in MULTIDIMENSIONAL model hence we can write simple query to extract data from database. ETL Tool is used for extracting data from the legecy system and load it into specified database with some processing of cleansing data. OLAP Tool is used for reporting process . Here data is available in multidimensional model hence we can write simple query to extract data from database.

Answer»

ETL TOOL is used for extracting data from the legecy system and LOAD it into specified database with some PROCESSING of cleansing data.

OLAP Tool is used for reporting process . Here data is available in MULTIDIMENSIONAL model hence we can write simple query to extract data from database.

ETL Tool is used for extracting data from the legecy system and load it into specified database with some processing of cleansing data.

OLAP Tool is used for reporting process . Here data is available in multidimensional model hence we can write simple query to extract data from database.

Discussion

No Comment Found

Related InterviewSolutions

We Will Be Using Pdi Integrated In A Web Application Deployed On An Application Server. We’ve Created A Jndi Datasource In Our Application Server. Of Course Spoon Doesn’t Run In The Context Of The Application Server, So How Can We Use The Jndi Data Source In Pdi?
I’ve Got A Transformation That Doesn’t Run Fast Enough, But It Is Hard To Tell In What Order To Optimize The Steps. What Should I Do?
Why Can’t I Duplicate Fieldnames In A Single Row?
How Do You Duplicate A Field In A Row In A Transformation?
Define Multi-dimensional Cube?
Define Mdx?
What Are Various Tools In Etl?
Wha Is Xml?
Differentiate Between Etl Tool And Olap Tool?
What Do You Understand By Three Tier Data Warehouse?