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

Can anybody tell me what are the tuning problems?

0 Answers  


What is batch processing in Business Objects?

2 Answers  


What is the difference between slice and dice and cross tab report?

0 Answers  


I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  


how many reports have u created ? explain a few.

1 Answers   InfoStep, Ness Technologies, TCS,






I have all the latest SAP – Business Objects - XI Certification Dumps, SABE201: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level One SABE301: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level Two SABE401: BUSINESS OBJECTS Enterprise Certified Professional XI – Level Three SABE501V3.0: BUSINESS OBJECTS Certified Professional – BUSINESS OBJECTS Enterprise XI 3.0 – Update. RDCR201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR301:1 BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR08301: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08401: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 QAWI201V3.0: BUSINESS OBJECTS Certified Professional Web Intelligence XI 3.0 QAWI301V3.0: BUSINESS OBJECTS Certified Professional BUSINESS OBJECTS Web Intelligence XI 3 DMDI201: BUSINESS OBJECTS Data Integrator XI – Level One DMDI301: BUSINESS OBJECTS Data Integrator XI – Level Two You can get Guarantee Pass 100 % Score with these Dumps, If interested in any of the dump, drop me a mail to: srivatsav.2k5@gmail.com with Certification code

7 Answers   IBM, SAP Labs,


Explain what are the steps to be taken to schedule the report?

0 Answers  


Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  


every alternative row should be hilighted ? how u can ?

1 Answers  


I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

2 Answers   TCS,


how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,


Categories