what is the diff between etl tool and olap tool
Answers were Sorted based on User's Feedback
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 |
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 |
What is domain? How many are there in a basic setup? What are they?
what are the day to day activities of BO administrator ?
what is main functional differences between BO and COGNOs?
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
What is the difference between master-detail and Breaks?
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
I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help
limitaions of cross tab ?
What is the difference between datawarehousing and businessintelligence?
can anybody tell me about issues faced while creating reports
IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER
What is mean by stored procedure ? and how we can generate stored procedure universe?