Informatica

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).

Introduction

1. How to Download Informatica 9.6.1
2. Step by Step approach to install Informatica
3. How to Configure the Repository Service & Integration Service
4. PowerCenter Repository Manager
5. Introduction to PowerCenter Designer
6. PowerCenter Source Analyzer

Data

1. ODBC Connection
2. Import Data from Relational Database
3. How to Import Data from Flat File
4. Import Data from Excel Workbook

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

Transformations

1. Aggregator Transformation
2. Expression Transformation
3. Sequence Generator Transformation
4. Sorter Transformation
5. Remove Duplicates using Sorter transformation
6. Joiner Transformation
7. Master Outer Join
8. Detail Outer Join
9. Full Outer Join
10. Filter Transformation
11. Rank Transformation
12. Rank Transformation with Group By
13. Router Transformation
14. Union Transformation
15. Lookup Transformation
16. Unconnected Lookup Transformation

Thank You for Visiting Our Blog