Informatica Online Training

Course Syllabus:

A. Introduction to Informatica

1. Overview
2. Informatica Architecture
3. Informatica Products
4. Basic Definitions
5. Folders – sub folders
6. Tools and their roles
7. Installation of Informatica

B. Informatica Designer – Introduction

1. Introduction to designer
2. Designer interfaces
3. Defining Sources
4. Logon to designer
5. Designer tools
6. Database as a source
7. Flat Files as source
8. Defining Targets
9. Importing from database
10. Creating a new target
11. Creating target database objects

C. Informatica Designer

1. Mapping Introduction
2. Source Qualifier
3. Mapping- Table to Table
4. Mapping flat File to Table
5. Ports
6. SQL Override-source Qualifier Transformation
7. Rank Transformation
8. Lookup Transformation (Connected & Unconnected)
9. Update strategy Transformation
10. Sequenced Generator Transformation
11. Source Qualifier Transformation
12. Transaction control Transformation
13. Joiner Transformation
14. Expression Transformation
15. Connected/Unconnected Transformations
16. Active and Passive Transformations
17. Mapping source Qualifier as Filter
18. Source qualifier to join data
19. Filter Transformation
20. Router Transformation
21. Aggregator Transformation
22. Stored Procedure Transformation (Connected & Unconnected)
23. Union Transformation
24. XML Transformation
25. Mapping wizards
26. Implementing Type-I, Type-II, Type-III Mappings

D. Informatica – Workflow Manager :

1. Workflow Introduction
2. Tasks
3. Connections
4. Workflow tools
5. Defining tasks
I. Command Task
II. Decision Task
III. Session Task
IV. Event Wait & Event Raise
V. Link Conditions
VI. Email Task
VII. Timer Control
6. Setting Properties of session Task
7. Starting Workflow
8. Monitoring Workflow
9. Scheduling Workflow
10. Creating Workflow

Informatica online training