Informatica Tutorial

In this Informatica tutorial, we will show you the step-by-step process of connecting with different data sources. Next, extract data from the data source, and transform the data using transformations. The last section of this covers the creating session and workflow and loads data into the destination with screenshots.

Informatica is the Market Leader in ETL tools, and over 5800 enterprises depend on this complete data integration solution. This business intelligence tool is mainly used to build powerful business applications for data extraction from Source(s), transforming and loading data into the target(s). This page explains everything about this data integration tool or ETL tool. Use this Informatica to learn all its features.

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

Informatica Tutorial Introduction

This data integration tool is a complete data integration solution provided by Oracle to perform data extraction from database management systems, perform data cleansing to process data, and load it into data warehousing or target database.

This is an introduction to this Informatica, which covers the installation of the data integration tool, configuring Powercenter, Workflows, etc.

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

  1. How to Download the Software
  2. Step by Step approach to installing Software
  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 Tutorial on Data Connections

The PowerCenter accesses information or data from different sources. They are Flat files, XML, Relational Databases, SAP Hana, Teradata, Mainframes, Excel, and Access. Similarly, it supports the same destinations to load data.

This section of Informatica Tutorial covers the different types of Data Connections and teaches basic ETL operations such as extraction, transformation, and load.

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

Informatica Transformations

This section covers the list of available Transformations.

  1. List of Transformations
  2. Aggregator
  3. Expression
  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.
    1. Lookup Transformation
    2. Unconnected Lookup
  8. Normalizer
  9. Rank Transformation
  10. Rank Transformation with Group By
  11. Router Transformation
  12. Sequence Generator
  13. Sorter Transformation
  14. Sorter Transformation – Remove Duplicates
  15. Source Qualifier
  16. SQL Transformation
  17. Stored procedure Transformation
  18. Transaction Control
  19. Union Transformation
  20. Update Strategy
  21. Update Strategy using Session Properties
  22. Example for Update Strategy
  23. XML Generator
  24. XML Parser
  25. XMLSource Qualifier
  26. Pre SQL and Post SQL

Learn Informatica Sessions & Mappings

This section explains the creation of Informatics Sessions, Mapping, and Workflow. These are very helpful in running the applications.

This section of the Informatica tutorial is the most important section for learning data management. Because of its reusability in all the transformations.

  1. Target Designer
  2. Create a Target table using the 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

Comments are closed.