H2K Infosys | Informatica Online Course Details

Course is customized to individual need. This will help to expand your skill sets and give confidence to take new challenging role.

Details:

CLASS-1

• Introduction and Architectural Overview Extraction, Transformation and loading process PowerCenter 8.x architecture
• Basic Element of Data Warehouse
• Source System
• Data Staging Area
• Facts & Dimensions
• Data warehouse and Latency
• Data Integration
• Repository Topics
• Repository Server and agent
• Repository maintenance
• Repository Server Administration Console
• Security, Repository, privileges and folder permissions
• Objects sharing, searching, and locking
• Metadata extensions
• Lab 1- Create a Folder

CLASS-2

• Source Object Definitions
• Source types
• Source properties
• Lab 2- Analyze Source Data
• Target Object Definitions
• Target types
• Target properties
• Lab 3- Import Target Schema
• Transformation Concepts
• Transformation types and views
• Transformation features and ports
• Expression transformation
• Informatica functions and data types

CLASS-3

• Mappings
• Mapping components
• Source Qualifier transformation
• Pre SQL and Post SQL
• Mapping validation
• Data flow rules
• Objects export and import
• Lab 4 - Create a Mapping

CLASS-4

• Workflows
• Workflow Tools
• Workflow Structure and configuration
• Workflow Tasks
• Workflow Design and properties
• Session Tasks
• Session Task properties
• Session components
• Transformation overrides
• Session partitions

CLASS-5

• Workflow Monitoring
• Workflow Monitor views
• Monitoring a Server
• Actions initiated from the workflow Monitor
• Truncating Monitor Logs
• Lab 6 - Start and Monitor a Workflow

CLASS-6

• Debugger
• Debugger features
• Debugger windows
• Tips for using the Debugger
• Lab 7 –The Debugger
• Filter transformation
• Filter properties
• Lab 8- Flat File Wizard and Filter

CLASS-7

• Aggregator transformation
• Aggregation function and expression
• Aggregator properties
• Using sorted data
• Incremental Aggregation
• Joiner transformation
• Joiner types
• Joiner conditions and properties
• Joiner usage and Nested joins
• Lab 9 – Heterogeneous join

CLASS-8

• Sorter transformation
• Sorter properties
• Sorter limitations
• Lab 10 – Sorter
• Lookup transformation
• Lookup principles
• Lookup properties
• Lookup techniques
• Lab 11 – Basic Lookup

CLASS-9

• Target options
• Row type indicators
• Row loading operations
• Constraint- based loading
• Rejected row handling options
• Lab 12 – Deleting Rows
• Update Strategy transformation
• Update strategy expressions
• Smart aggregation
• Refresh strategies

CLASS-10

• Lab 13 – Data Driven Inserts and Rejects
• Router transformation
• Using a router
• Router groups
• Lab 14 – Router
• Mapping Parameters and variables
• Mapping parameters and variables usage
• System Variables
• Variables functions
• Conditional Parameters and Variables
• Mapping parameter and variable usage
• System Variables
• Variable functions

CLASS-11

• Conditional Lookups
• Usage and techniques
• Advantage
• Functionality
• Lab 15 – Straight Load
• Lab 16 – Conditional Lookups

CLASS-12

• Heterogeneous Targets
• Heterogeneous target types
• Target type conversions and limitations
• Lab 17 – Heterogeneous Targets
• Mapplets
• Functionality and Advantages
• Mapplet types and structure
• Mapplet limitations
• Lab 18 – Mapplets

CLASS-13

• Reusable transformations
• Advantages
• Limitations
• Promoting and copying transformations
• Lab 19 - Reusable transformations
• equence Generator transformation
• Using a sequence Generator
• Sequence Generator properties
• Dynamic Lookup
• Dynamic lookup theory
• Usage and functionality
• Advantages
• Lab 20 – Dynamic Lookup

CLASS-14

• Concurrent and sequential Workflows
• Concurrent Workflows
• Sequential Workflows
• Stopping, Starting and suspending tasks and workflows
• Lab 21 – Sequential Workflow
• Additional Transformations
• Rank transformation
• Normalizer transformation
• Customer Transformation
• Transformation Control transformation
• Error Handling
• Overview of Error Handling Topics
• Velocity Error Handling Strategies

CLASS-15

• Performance Tuning
• Overview of System Environment
• Identifying Bottlenecks
• Lab 22 – Error handling fatal and non Fatal
• Mapping Variables
• Introduction to Mapping Variable and Parameters
• Creating Mapping Variables and Updating Variables
• Creating Parameter File and associating file to a Session
• Lab 26 - Override Mapping Variable with Parameter Files
• Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable
• Reusable Workflow Tasks
• WorkLets
• Worklets Limitation
• Lab 28 – Create Worklets using Tasks
• Command Line Interface ( PMCMD)
• Overview of PMCMD and functions

CLASS-16

• Informatica 8.X overview

CLASS-17

• New Features of Informatica 8.x

CLASS-18

• Informatica Assignment 1

CLASS-19

• Informatica Assignment 2

CLASS-20

• Informatica Assignment 3