Informatica Level 2 Developer Course – (Advanced) Curriculum

Section 1: Data Warehouse Concepts
Introduction to Data warehouse
What is Data warehouse and why we need Data warehouse
Star schema/Snowflake schema/Galaxy schema
Dimensions / Facts tables.
Section 2: Introduction and Architecture
ETL (Extract-transform-load) Overview
Informatica PowerCenter as an ETL tool.
Architecture and Software Overview
Definition of Domain, Repositories, Integration Services.
Overview of Informatica PowerCenter Administration Console.
Section 3: Client Software Overview
Introduction to Designer Interface
Introduction to Workflow Manager Interface
Introduction to Workflow Monitor
Introduction to Repository Manager
Nature of ODBC in the Designer
Section 4: Source Object Definitions
Flat File Sources
Relational Sources
Data Previewer
LAB: Import a Source
LAB: Create a Source manually.
Section 5: Target Object Definitions
Target Definitions
Target Properties
Flat File Targets
Relational Targets
LAB: Import a Target
LAB: Create a Target, manually.
Section 6: Mappings
Defining a Data Flow Diagram
Transformation Objects and Views
Source Definition and Source Qualifier
Pre-SQL and Post-SQL Rules
Expression Transformation
Informatica Functions
Variable Ports
Data Types
Mapping Validation
LAB: Create a Working Mapping
Section 7: Workflows
Workflow Tools
Workflow Structure
Workflow Connections
Workflow Tasks
Workflow Design Process
Workflow Properties
Workflow Links
Session Tasks
LAB: Configure a Workflow and Session. And call previously created mapping.
LAB: Command line execution of a workflow.
Section 8: Monitoring Workflows
Workflow Monitor Views
Monitoring a Server
Actions Initiated from the Workflow Monitor
LAB: Run and Monitor the Workflow. View Logs and summary load information.
LAB: Demonstration of Designer Features
Section 9: Debugger
Debugger Features
9.2 Debugger Windows and Indicators
9.3 Debugger Best Practices
9.4 LAB: Debug a Mapping
Section 10: Transformation
What is a transformation in Informatica PowerCenter space?
10.2 Active and passive transformation
Section 11: Source Qualifier
Source Qualifier transformation Overview
Use of source qualifier to restrict data read from source.
Section 12: Expression Transformation
Expression Functionality
Use of a Variable port to hold previous row value.
Few common extression – IF-ELSE, ISNULL, etc
LAB: Create a Expression Transformation, Run Workflow
Section 13: Filter Transformation
Filter Functionality
Filter Properties
Filter Versus DB Where Clause
LAB: Create a Filter Transformation, Run Workflow
Section 14: Sorter Transformation
Sorter Functionality
Sorter Properties
Sorter Versus Database Order by Clause
LAB: Use Sorter transformation in a mapping
Section 15: Aggregator Transformation
Aggregator Transformation
Aggregator Expressions and Functions
Data Flow Rules
LAB : Use aggregator in a mapping.
Section 16: Joiner Transformation
Homogeneous and Heterogeneous Joins
Joiner Conditions and Properties
Joiner Usage
Types of Joins
LAB: Add Sorter, Joiner, and Aggregator
Section 17: Lookup Transformation
Lookup Principles
Lookup Properties
Lookup Caching
Lookup Versus Database Join
LAB: Create a Basic Lookup
Connected Lookup Vs Unconnected Lookup
Dynamic lookup transformation
Section 18: Unconnected Lookups
Usage and Techniques
Conditional Lookups
LAB: Create an Unconnected Lookup
Section 19: Update Strategy Transformation
Update Strategy Transformation
Update Strategy Expressions
Update Strategy Best Practices
LAB: Create a Type 2 Dimension Update
Section 20: Router Transformation
Router Functionality
Router Groups
LAB: Use a Router to Delete Rows
Section 21: Sequence Generator Transformation
Sequence Generator Functionality
Sequence Generator Properties
Sequence Generator Best Practices
LAB: Create a Sequence Generator transformation in mapping.
Section 22: Normalizer Transformation
Normalizer Transformation Functionality
LAB: Create a mapping which uses normalizer transformation.
Section 23: Union Transformation
Overview of Union Transformation
LAB: Create a mapping which uses union transformation.
Section 24: Parameters and Variables
Parameter Scoping
System Variables
Mapping Parameters and Variables
Variable Functions
Section 25: Mapplets
Mapplet Designer
Mapplet Advantages
Mapplet Types and Rules
Mapplet Parameters and Variables
Mapplet Designer Best Practices
LAB: Build a Mapplet
Section 26: Reusable Transformations
Transformation Developer
Transformation Developer Best Practices
LAB: Create and Use a Reusable Transformation
Section 27: Workflow Configuration
Server Connections
Reusable Workflow Schedules
Reusable Session Configurations
LAB: Create a Sequential Workflow
LAB: Create a Concurrent Workflow
Section 28: Reusable Tasks
The Command Task
Reusable Task Best Practices
Section 29: Non-Reusable Tasks
The Decision Task
The Assignment Task
The Timer Task
The Control Task
The Event Wait Task
The Event Raise Task
LAB: Create Event Wait/Event Raise and Timer
LAB: Create a Control and Assignment Task
LAB: Create a Command Line Task
Section 30: Worklets
Reusable Worklet
Non-Reusable Worklet
Worklet Best Practices
  • $999.00
  • 45 Days
  • Course Certificate