Explain the difference between etl tool and olap tools?
Submitted by: AdministratorETL 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online ETL (Extract, transform, load) Job Interview Questions And Answers
Top ETL (Extract, transform, load) Questions
☺ | Explain What is ETL process ?How many steps ETL contains explain with example? |
☺ | How to calculate fact table granularity? |
☺ | Explain What is Full load & Incremental or Refresh load? |
☺ | Explain the difference between etl tool and olap tools? |
☺ | Explain What are the different versions of Informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |