What is ETL?
ETL is a type of data integration and involves an architecture that extracts, transforms, and then loads data in the target database or file. It is the foundation of a data warehouse.
An ETL system does the following:
Extracts data from source systems
Transforms and cleans up the data
Indexes data
Summarises data
Loads data into the warehouse
Tracks changes made to the source data required for the warehouse
Restructures keys
Maintains the metadata
Refreshes the warehouse with updated data
What is Informatica?
Informatica is a data integration tool based on ETL architecture. It provides data integration software and services for various businesses, industries and government organisations including telecommunication, health care, financial and insurance services.
What is the use of Informatica ETL tool?
Informatica PowerCenter is a premium data integration solution available today. The reason it provides the best solution in large enterprises is because it is:
database neutral and hence can communicate with any database
the most powerful data transformations tool. It converts one application’s data to another’s format.
Course Duration
60 Hrs
Prerequisite:
A basic knowledge of SQL can be an added advantage.
Curriculum:
ETL Development:
Introduction to ETL and its importance in data warehousing
Setting up and installation of various ETL tools
Optimising ETL tools for best results based on specific job requirements
OLAP, ETL and OLTP systems
Data modelling and dimensional modelling
Working with star and snowflake schemas
Dimensions, measures and fact tables in data warehousing
Data types and performance tuning in ETL
SCD types and various methods of handling SCD data
Various types of data transformation techniques
Source qualifier transformation and mapping
Curriculum :
Informatica architecture and PowerCenter
Installation and configuration of Informatica
Managing and monitoring Informatica workflow
Using PowerCenter to handle jobs and tasks
Informatica workflow variables and session parameters
Working with Informatica Admin Console
Informatica performance tuning
Managing Informatica Repository
ETL functionalities and scenarios
Informatica SQL and XML transformation
