Informatica Level 1 Developer Course – (Basic) Curriculum
Section 1: Data warehousing and Informatica Power Center: Terminology and Architecture
Data warehousing Architecture
ETL process
Dimensional Modelling -SQL need and brief
Introduction about Informatica Power Center
Informatica Power Center Architecture
Section 2: Powercenter Configuration And Client Tools Overview
Configure Informatica repository in Client tools
Create a folder for Working on Repository
PowerCenter Designer
Workflow Manager
Workflow Monitor
Repository Manager
Section 3: PowerCenter Designer Interface
Source analyzer component
Target designer
Transformation developer
Mapplet designer
Mapping designer
Section 4: Mapping Fundamentals -Create First Mapping
Create Relational and File source objects
Create Relational and File target objects
Preview source and target data using Informatica Objects
Create Informatica mapping
Section 5: Workflow Fundamentals -Create First Workflow
Create Relational Connection
Create a session task in Task Developer
Configure Session properties
Create a Workflow
How to Create a Session task in Workflow Designer tool
Run Informatica workflow and Monitor its run
Monitor the workflow run status and check logs
Section 6: Informatica Transformation Concepts
Transformation types
Power Center Data Types
Power Center -Working with Expressions
Create and Configure a Transformation
Transformation Ports and connections
Power Center Functions
Section 7: Source Qualifier Transformation
Transformation Overview
Source Qualifier Transformation Properties
Create a sample mapping using Source Qualifier Transformation
Configure SQ Transformation properties in Mapping
Create a Workflow and session for this mapping
Run Workflow and Monitor output
Section 8: Informatica Joiner Transformation
Transformation Overview
Joiner Transformation Properties
Create a sample mapping using Joiner Transformation
Create a Workflow and session for this mapping
Run Workflow and Monitor output
Performance Tips and Limitations for Joiner Transformation
Section 9: Informatica Filter Transformation
Transformation Overview
Create a sample mapping using Filter Transformation
Create a Workflow and session for this mapping
Run Workflow and Monitor output
Performance Tips for Filter Transformation
Section 10: Aggregator Transformation
Transformation Overview
Uasge and Purpose of this Transformation
Transformation properties
Aggregator caches
Aggregate functions
Create an aggregator transformation
Performance tuning tips
Section 11: Sequence Generator Transformation
Transformation Overview
Uasge and Purpose of this Transformation
Transformation properties
Sequence Generator ports
Create a sequence generator in a mapping
Section 12: Router Transformation
Transformation Overview
Uasge and Purpose of Router Transformation
Working with Router Groups
Create a mapping with router transformation as an example
Difference between Filter and Router transformations
Section 13: Rank Transformation
Transformation Overview
Uasge and Purpose of Router Transformation
Transformation properties
Rank and Group ports selection
Create a Rank transformation with a usecase
Section 14: Sorter Transformation
Transformation Overview
Sorter Transformation properties
Create a sample mapping using Sorter Transformation
Create a Workflow and session for this mapping
Run Workflow and Monitor output
Section 15: Union Transformation
Transformation Overview
Rules and guideleines Transformation
Union Transformation Components
Union groups and Group ports creation
Example of Union transformation to combine data
Section 16: Expression transformation
Transformation Overview
Transformation properties
Master and detial tables
Types of joins
Joiner transformation performance tips
sample mapping with joiner
Section 17: Normalizer transformation
Transformation Overview and purpose
Types of Normalizer transformations
Normalizer properties
Create a mapping with Normalizer taking a business scenario
Section 18: Workflow and session
Workflow manager overview
Workflow overview
Workflow properties nad options
Session task over view and options
Cretae a sample workflow and session
Section 19: Transaction Control Transformation
Transformation Overview and purpose
Mapping Guidelines and Validation
Transaction control options
sample mapping
Section 20: Lookup Transformation
Transformation Overview and purpose
Types of Lookup transformations
Lookup ports and condition
How to use Connected lookup
How to use Un Connected lookup
Differenence between Connnected and Un Connected lookups
Lookup Properties
Lookup Caches Overview
Section 21: Update Strategy Transformation
Transformation Overview and purpose
Flagging Rows Within a Mapping
Specifying an Operation for All Rows
Specifying Operations for Individual Target Tables
sample mapping
Section 22: Mapping Parameters & Variables
Uses of mapping parametrs
Uses of mapping variable
Types of parametters in Informatica
How to define parametes and variables
Parameter file creation
How to use parameters and variables in mapping
Section 23: Mapletts in Informatica
About mapplets and purpose
Mapplets guidelines and limitations
Mapplet input
Mapplet output
How to use a mapplet in a mapping
Section 24: User-Defined Functions
About user defined functions
Types of user defined functions
Steps to create a function
using/calling of user defined function in informatica
Section 25: Workflow scheduler -options
About worflow scheduler
Create a schedular
Schedular configurations
Schedular types
how to schedule a workflow to run
Section 26: Project Related and additionals
Section 27: Exposure on projects running in real time
Section 28: Project scenarios and assignments -POC project if possible
Section 29: Resume preparation assistance
Section 30: Mock interviews
Section 31: Complete Job assistacne
REVIEWS / TESTIMONIALS
Took the Salesforce dot com (SFDC) LIVE online course with Eduzza. Course instructor was very knowledgeable, and handled the class very well in terms...Read more
Abhishek Kumar
Business AnalystMy association with Eduzza began when I enrolled for the Oracle HFM (Hyperion Financial Management) course. Since I am a Business Analyst, I was a...Read more
Gomesh Desai
Business AnalystI had a very good experience with the UI Web Development course which I took with Eduzza. Instructor paced the training according to my grasping of...Read more
Israt Ali
UI/UX ProfessionalI took the Business Analyst (BA) course from Eduzza. The best part about the course is that, variety of problems with real world use cases were...Read more
Rakesh P
Business AnalystI had attended a couple of demo sessions in Advance Web Development with other training companies before joining EDUZZA. With EDUZZA's first demo...Read more
Suvarna G
Web DeveloperFirst I will like to thank you for the C#.Net classes I'm currently taking; the instructor is wonderful, very easy to follow and understand. I feel...Read more
Guisselle
Software DeveloperI was looking for a practical Business Analyst course and went through many other IT online training portals just when a friend of mine recommended...Read more
Cong Nie
Business AnalystEDUZZA's Business Analyst Certification Training was indeed very good. The training sessions were very informative and clear. The trainer's own...Read more
Deepali Pandit
BAInitially I was not sure about completing the Hadoop EcoSystem course in 30 hours but now I can say that EDUZZA's instructor Sitaram gave complete...Read more
Chenna Manukonda
Hadoop DeveloperOne of the best things about EDUZZA's "QA Training – Software Testing Course" online training is that it covers the practical aspects of the...Read more
Paulomi Parekh
QA Analyst
