Data Warehouse ETL tools Informatica

Data Warehousing ETL Tool

You are here: Home Data Warehouse & ETL Tutorial

Data Warehouse & ETL Tutorial:

Data Warehouse is where data from different source systems are integrated, processed and stored. Data Warehouse data is a non-production data which is mainly used for analyzing and reporting purposes. Business users and higher management authorities use the data warehouse data to analyze, and to make important business decisions. Data Warehouse collects large volume of data from variant sources with many different data formats. The ETL(Extraction, Transformation and Loading) process handles these data and transforms it into a more consistent, standard formatted data. This ETL process is done with the help of an ETL tool and most widely used tools are Informatica, Data Stage, Ab Inito, Oracle Warehouse Builder etc.

This Data Warehouse and ETL tutorial section explains the data warehouse/ETL concepts, ETL tools and their usage with practical examples. Go through the links given below to read more.

Data Warehouse Concepts | Database - RDBMS | ETL Tools | ETL Tools: What to Learn? | ETL Concepts | ETL Tools - Informatica | Informatica Interview Questions & Answers | Learn Informatica - Tutorial | Informatica - Transformations | ETL Tools - Transformation Manager | ETL Testing

You might also like

Microsoft Press Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 (Microsoft Press Training Kit)
Book (Microsoft Press)
  • Used Book in Good Condition

Why Microsoft's SQL Server 2014 may threaten Oracle's leadership  — Market Realist
The combination of social, mobile, data analytics, and cloud (or SMAC) computing has led to unprecedented growth in data volumes. This growth in data volumes presents multiple challenges as well as opportunities.

Morgan Kaufmann Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses (The Morgan Kaufmann Series on Business Intelligence)
Book (Morgan Kaufmann)
  • Used Book in Good Condition
Ocean Software International, Inc. Data Warehouse and Business Intelligence Architecture Design eCourse
Software (Ocean Software International, Inc.)
  • Audio / Video in Flash eCourse
  • 12 Course Segments, Note Book and Examples
  • Taught by a 20 year Data Warehouse Veteran
Rocky Nook Data Warehousing with SAP BW7 BI in SAP Netweaver 2004s: Architecture, Concepts, and Implementation
Book (Rocky Nook)
  • Used Book in Good Condition
McGraw-Hill Osborne Media Oracle NoSQL Database: Real-Time Big Data Management for the Enterprise
Book (McGraw-Hill Osborne Media)
  • Used Book in Good Condition