ETL (Extract, transform, load) Question:
Explain the difference between etl tool and olap tools?
Answer:
ETL tool is ment for extraction data from the legecy systems and load into specified data base with some process of cleansing data.
ex: Informatica,data stage ....etc
OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional model. so that u can write smple query to extract data fro the data base.
ex: Businee objects,Cognos....etc
ex: Informatica,data stage ....etc
OLAP is ment for Reporting purpose.in OLAP data avaliable in Mulitidimectional model. so that u can write smple query to extract data fro the data base.
ex: Businee objects,Cognos....etc
| Previous Question | Next Question |
| Explain What are the various transformation available? | How to extract SAP data Using Informatica? What is ABAP? What are IDOCS? |