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 |
1)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI (R2)?? 2)Difference between oracle 8i amd oracle 9i? 3)Difference between SQL and PL/SQL? 4)what is Broad cast Agent? 5)what is prompts? 6)master detail format means? 7)performance tuning of reports means? 8)ad-hoc reports means? 9)can't we generate reports without creating universe?
What is the definition of derived table ?
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
Explain how to schedule the report in b.o?
why we use aggregation in lower level
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
every alternative row should be hilighted ? how u can ?
What are templates? Explain what you have created?
how to add duplicte rows to the existing report in webi ?
What is the need of live office connector
what is meant by slowly changing dimensions?
How to hide the table s in webi?can any one tell me plzzzzzzzz