EDUZZA

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
TAKE THIS COURSE
  • $999.00 $899.00
  • 45 Days
  • Course Certificate

REVIEWS / TESTIMONIALS