Tutorial Gateway

Informatica Tutorial

Informatica is the Market Leader in ETL tools, and over 5800 enterprises depends on it. Informatica is mainly used to build powerful business applications for extracting data from Source(s), transforming and loading data into target(s).

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, creating session and workflow, and load data into destination with screenshots.

Informatica Introduction

  1. How to Download Informtica
  2. Step by Step approach to install 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

Data Connections

  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

Informatica Sessions & Mappings

  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

Informatica 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