Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!
Home » 2015 » May (Page 6)

Informatica Tutorial – Part 1

ETL Tool – Informatica Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation. In the following section, we will try to explain the usage of Informatica in the Data Warehouse environment...
Read More

What is OLAP?

OLAP, an acronym for ‘Online Analytical Processing’ is a technique by which the data sourced from a data warehouse or data mart is visualized and summarized to provide perspective multidimensional view across multiple dimensions. Generally OLAP refers to OLAP Tools(e.g Cognos, Business Objects etc.,) that...
Read More

BI Reporting

Business Intelligence Reports: Data is collected from various sources and cleansed or transformed into a form required by data warehouse or data mart decision support systems. BI tools provide a means of taking advantage of these data contained within a data warehouse or data mart...
Read More

ETL & Data Warehouse

ETL Process: ETL, an acronym for ‘Extraction, Transformation and Loading’ is a collection of processes associated with extracting the source data, transforming that data and finally loading that data into a data warehouse. Before loading the required into data warehouse, it should be transformed in...
Read More

Dimensional Modeling

Dimensional Model comprises a fact table and many dimension tables and is used for calculating summarized data. Since Business Intelligence reports are used in measuring the facts(aggregates) across multiple dimensions, dimensional data modeling is the preferred modeling technique in a BI environment. A Fact table...
Read More

Data Modeling

Data Modeling is about representing the real world set of data structures or entities and their relationships in the form of Data Models, required for a database. Simply put, data model is a visual representation of the database. Data Modeling consists of various types and...
Read More

Business Modeling

Business Modeling depicts the overall picture of a business like what is it about, what specific business problem it is intend to solve and how the information flows from source to destination. Business modeling involves, business models and diagrams that provide information in a graphical...
Read More