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 |
When to use local filter and when to use global filter?
how to link 3 fact tables
1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
What is meant by data federator and what is the use of it?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?
7.what is data mart?
what is the use of merge option in webi reports? explain with example?
how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?
How to change English language to Chinese in BO Desiner (Universe)?
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?