what is the diff between etl tool and olap tool

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3214


Explain what are the measure objects?

641


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

4611


Explain is there any default username & pwd for bo designer & supervisor?

686


how get the grand total in master-detail report?

1898






What is object stores?

662


what is document design in boxi,have u participate in that

1731


Can we create universe with no cache??

2049


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

792


Can we configure two instances of CMS pointing to two different CMS system databases?

1584


Can anybody tell me what are the tuning problems?

1676


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1992


What is the profile and package?

1883


Explain when we use aggregate awareness function in designer?

672


How to open a universe with out using the Designer ??

6814