Informatica Training

Informatica Course Content:

Introduction to Data warehousing:

  • Introduction and Architecture
  • Architecture and Software Overview
  • ETL and ELT Architecture Overview
  • Partitioning and Parallelism Introduction
  • Power Center Services RAM Utilization
  • Differences Between 32 bit and 64 bit
  • Client Software Overview
  • Introduction to Designer Interface
  • Introduction to Workflow Manager Interface
  • Introduction to Workflow Monitor
  • Introduction to Repository Manager
  • Software Demonstration
  • Source Object Definitions
  • Flat File Sources
  • Relational Sources
  • Data Previewer
  • Metadata Extensions

Assignment:

  • Import a Source
  • Target Object Definitions
  • Target Definitions
  • Target Properties
  • Flat File Targets
  • Relational Targets

Assignment:

  • Import a Target
  • 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

Assignment:

  •  Create a Working Mapping
  • Workflows
  • Workflow Tools
  • Workflow Structure
  • Workflow Connections
  • Workflow Tasks
  • Workflow Design Process
  • Workflow Properties
  • Workflow Links
  • Session Tasks

Assignment:

  • Configure a Workflow and Session
  • Monitoring Workflows
  • Workflow Monitor Views
  • Monitoring a Server
  • Actions Initiated from the Workflow Monitor
  • Filtering Views
  • Truncating Monitor Logs
  • Stop Versus Abort

Assignment:

  •  Run and Monitor the Workflow
  • Demonstration of Designer Features
  • Debugger
  • Debugger Features
  • Debugger Windows and Indicators
  • Debugger Best Practices

Assignment:

  •  Debug the Mapping
  • Filter Transformation
  • Filter Functionality
  • Filter Properties
  • Filter Versus DB Where Clause

Assignment:

  • Create a Filter Transformation, Run Workflow
  • Sorter Transformation
  • Sorter Functionality
  • Sorter Properties
  • Sorter Versus Database Order by Clause
  • Aggregator Transformation
  • Aggregator Expressions and Functions
  • Using Unsorted and Sorted Data
  • Data Flow Rules
  • Aggregator Versus Database Group By
  • Joiner Transformation
  • Homogeneous and Heterogeneous Joins
  • Joiner Conditions and Properties
  • Joiner Usage
  • Nested Joins
  • Joiner Versus Database Join

Assignment:

  • Add Sorter, Joiner, and Aggregator
  • Lookup Transformation
  • Lookup Principles
  • Lookup Properties
  • Lookup Caching
  • Lookup Versus Database Join

Assignment:

  • Create a Basic Lookup
  • Target Options
  • Target Properties
  • WHERE Clause
  • Constraint-Based Loading
  • Target SQL Override Best Practices
  • Update Strategy Transformation
  • Update Strategy Transformation
  • Update Strategy Expressions
  • Update Strategy Best Practices

Assignment:

  • Create a Type 2 Dimension Update
  • Router Transformation
  • Router Functionality
  • Router Groups

Assignment:

  • Use a Router to Delete Rows
  • Data Driven Versus Session Switches
  • Parameters and Variables
  • Parameter Scoping
  • System Variables
  • Mapping Parameters and Variables
  • Variable Functions
  • Unconnected Lookups
  • Usage and Techniques
  • Advantages
  • Functionality
  • Conditional Lookups

Assignment:

  • Create an Unconnected Lookup
  • Heterogeneous Targets
  • Heterogeneous Target Types
  • Target Type Limitations and Conversions

Assignment:

  • Build Heterogeneous Targets
  • Mapplets
  • Mapplet Designer
  • Mapplet Advantages
  • Mapplet Types and Rules
  • Active and Passive Mapplets
  • Mapplet Parameters and Variables
  • Mapplet Designer Best Practices

Assignment:

  • Build a Mapplet
  • Reusable Transformations
  • Transformation Developer
  • Rules
  • Promoting and Copying Transformations
  • Transformation Developer Best Practices

Assignment:

  • Create and Use a Reusable Transformation
  • Sequence Generator Transformation
  • Sequence Generator Functionality
  • Sequence Generator Properties
  • Sequence Generator Best Practices

Assignment:

  • Create a Variable Based Sequence Generator
  • Error Logging
  • Setting On and Off
  • Data Rejects with Error Logging Off
  • Error Logging to Database Table and Flat File
  • Source Row Logging
  • Error Logging Best Practice Architecture
  • Workflow Configuration
  • Server Connections
  • Reusable Workflow Schedules
  • Reusable Session Configurations

Assignment:

  • Create a Sequential Workflow
  • Create a Concurrent Workflow
  • Reusable Tasks
  • The Command Task
  • The Email Task
  • Reusable Task Best Practices
  • Non-Reusable Tasks
  • The Decision Task
  • The Assignment Task
  • The Timer Task
  • The Control Task
  • The Event Wait Task
  • The Event Raise Task
  • Non-Reusable Tasks Best Practices

Assignment:

  • Create Event Wait/Event Raise and Timer
  • Create a Control and Assignment Task
  • Create a Command Line Task
  • Worklets
  • Reusable Worklet
  • Non-Reusable Worklet
  • Worklet Best Practices