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