what is the diff between etl tool and olap tool

Answers were Sorted based on User's Feedback



what is the diff between etl tool and olap tool..

Answer / chandra

ETL tool is used to extract, Load and Transform the data
from one system to another system. OLAP tool is a reporting
tool which will generates the reports that are useful for
dicison support for top level management

Is This Answer Correct ?    5 Yes 0 No

what is the diff between etl tool and olap tool..

Answer / d.shiva prasad

ETL tool are nothing but OLTP tool whereas OLAP tools are
report net tools

ETL(OLTP) are extracters tranfers and loaders type
OLAP tools are analysers

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Business Objects Interview Questions

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  


Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  


Can Bo generates the reports from cubical data ? Explain?

2 Answers   IBM,


What is the short cut join?

2 Answers   Wipro,


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1 Answers   CTC,


What is broad cast agent?

5 Answers  


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

1 Answers  


Who launches the supervisor product in Business Objects for first time?

2 Answers  


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

2 Answers  


what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


Explain in detail about type 2(scd),

1 Answers  


1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?

4 Answers   IBM,


Categories