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 the difference btween olap and oltp?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
How to create Universe using Flat file in BO6.0
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
what is universe null
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
What is drill across ? can anybody explain me in detail?
what is dashboards? what is metrics?
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?