|
What is the difference between ETL tool and OLAP tool?ETL is the process of Extracting, loading and transforming data into meaningful form. This data can be used by the OLAP tool for to visualize data in different forms. ETL tools also perform some cleaning of data. OLAP tools make use of simple query to extract data from the database.What is the difference between ETL tool and OLAP tool?ETL can extract, transform using various transformations that are available in the tool, and aggregate the data. The output can be used as an input for OLAP tool. ETL is the initial part of data warehousing. For generating cross tab report from the source tables, data warehouse takes very long time span. For efficiency, these tables are transformed into cubes and persisted in OLAP server. The analysis that is performed on the cubes is provided with pre-aggregated values. Hence, report generation will be much faster.
OLAP supports online reports after performing certain join operations and creating some cubes. OLAP consists of various applications for score carding, reporting, dashboards, consolidation, planning, analysis, master data management, workspace and foundation.
|
20 Cognos Interview Questions and Answers - Freshers, ExperiencedCognos interview questions - What are the products of Cognos? Can you set them in the order they were released?, How is report scheduling done in Cognos?, How do you create users in Cognos and assign them permissions?, Cognos Visualizer, Cognos Scripting, Snapshot, Transformer.
