What is 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 Oracle ETL Job Interview Questions And Answers
Top Oracle ETL Questions
☺ | What are the various methods of getting incremental records or delta records from the source systems? |
☺ | What is partitioning? What are the types of partitioning? |
☺ | Where do we use connected and un connected lookups? |
☺ | What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
☺ | Compare ETL & Manual development? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |