Informatica Tutorial

In this Informatica tutorial, we will show you the step by step process to connect with different data sources. Next, extract data from data source, transform the data using transformations. Last section of this Informatica tutorial covers the creating session and workflow, and load data into the destination with screenshots.

What is Informatica ETL Tool?

Informatica is the Market Leader in ETL tools, and over 5800 enterprises depend on it. The Informatica is mainly used to build powerful business applications for extracting data from Source(s), transforming and loading data into the target(s). In this Informatica tutorial page, we explain everything about this ETL tool.

The Informatica PowerCenter Client contains different applications or tools that help to design Mappings and Mapplets. Use this PowerCenter client to create a Session and WorKflow.

Informatica Introduction

This is an introduction to this Informatica tutorial, which covers, installation of Informatica, configuring Power center, Workflows etc.

Informatica PowerCenter application allows to load or extract data from multiple sources (Source Qualifier), transform the data as per the business requirements(transformation), and loads the processed data into the destination table (Target Designer).  

1. How to Download Informtica
2. Step by Step approach to installing InformaticaSoftware
3. How to Configure the Repository Service & Integration Service
4. PowerCenter Repository Manager
5. Introduction to PowerCenter Designer
6. PowerCenter Source Analyzer
7. Introduction to Workflow Manager
8. Introduction to Workflow Monitor

Informatica Data Connections Tutorial

Informatica PowerCenter accesses the information or data from different sources such as Flat files, XML, Relational Databases, SAP Hana, Teradata, Mainframes, Excel, and Access. Similarly, Informatica supports the same destinations to load data. This section of Informatica Tutorial covers the different types of Data Connections, and basic ETL operations.

1. ODBC Connection
2. Import Data from Relational Database
3. How to Import Data from Flat File
4. Import Data from Excel Workbook
5. Move Data from One SQL Database to another Database
6. Export Data from SQL Server to Flat File
7. Load Data From Text File to SQL Server
8. Load Multiple Text Files into SQL Server

Informatica Tutorial on Transformations

This section of Informatica tutorial covers the list of available Transformations.

1. List of Transformations
2. Aggregator Transformation
3. Expression Transformation
4. Filter Transformation
5. Java Transformation
6. Joiner Transformation
   1. Normal Join
   2. Master Outer Join
   3. Detail Outer Join
   4. Full Outer Join
7. Lookup Transformation
   1. Lookup Transformation
   2. Unconnected Lookup Transformation
8. Normalizer Transformation
9. Rank Transformation
10. Rank Transformation with Group By
11. Router Transformation
12. Sequence Generator Transformation
13. Sorter Transformation
14. Sorter Transformation – Remove Duplicates
15. Source Qualifier Transformation
16. SQL Transformation
17. Stored procedure Transformation
18. Transaction Control Transformation
19. Union Transformation
20. Update Strategy Transformation
21. Update Strategy using Session Properties
22. Example for Update Strategy
23. XML Generator Transformation
24. XML Parser Transformation
25. XMLSource Qualifier Transformation
26. Pre SQL and Post SQL

Informatica Sessions & Mappings

This Informatica tutorial section explains the creation of Informatics Sessions, Mapping, and Workflow. This section of Informatica tutorial is the most important section because of its reusability in all the transformations.

1. Target Designer
2. Create Target table using Source Definition
3. Create New Target Table
4. How to Create Mapping
5. Create Session
6. How to Create Reusable Session
7. Create Workflow
8. Creating Workflow using Wizard
9. Command Task
10. Event Wait Task