Description

Informatica Training in Bangalore Offered by Locus IT with 100% Hands on Practical Classes with Best Industrial Experts and Working with Real Time Projects.

Course Content

1. Introduction to DWH
2. Introduction to Informatica
3. Informatica Architecture , Power Center, Components

• Designer
• Workflow manager
• Workflow monitor
• Repository Manager
• Admin console

1- Informatica Designer

• Introduction to designer
• Logon to designer

Defining Sources

• Database as a source
• Flat Files as a source
• XML Files as a source

Defining Targets

• Database as a target
• Flat Files as a target
• XML Files as a target

Mapping Introduction

• Designer Tools
• Source Analyzer
• Target Designer
• Transformation Developer
• Mapplet Designer
• Mapping Designer

2-Informatica Workflow Manager

Workflow manager Tools

• Task Developer
• Worklet Designer
• Workflow Designer

Session properties 

• Informatica Workflow Monitor
• Log Details and Debugging

Types of Transformations

• Active Transformations
• Passive Transformations
• Connected Transformations
• UnConnected Transformations

List of Transformations

• Source Qualifier Transformation
• Filter Transformation
• Sorter Transformation
• Expression Transformation
• Aggregator Transformation
• Router Transformation
• Union Transformation
• Rank Transformation
• Sequence Generator Transformation
• Joiner Transformation
• Stored procedure Transformation
• Normalize Transformation
• XML source qualifier Transformation
• Transaction Control Transformation
• SQL Transformation
• Look up Transformation
• Update strategy Transformation

Slowly Changing Dimension

Manual and Wizard 

• SCD1
• SCD2
  • Version
  • Date
  • Flag
• SCD3

Advanced Topics

1-  Transformation Developer

• Mapplet
• Mapplet advantage/ restrictions
• Worklet

2- Tasks

Reusable task

• Session
• Command
• Email

Non- Reusable task

• Timer
• Event wait
• Event raise
• Decision

3- Mapping Parameter

Variables

• Local Variables
• Mapping Variables
• Session Variables
• Workflow Variables
• Email Variables
• Built-In Variables (System information,$$$sessionstarttime)
• Connection Variables ($$RDBMSconn1)
• Set variable
• Setcountvariable
• Setmaxvariable
• Setminvariable
• File List/Indirect Method (to load multiple files)
• Scheduling informatica workflow
• PMCMD commands to run workflow
• Incremental aggregation
• Pushdown Optimization
• Target Load plan/ Stored procedure load plan
• Constraint based load ordering
• Test load plan
• Collect performance data
• Debugging Mapping
• Tracing levels
• Explaining Bad files (rejected records)
• Bulk Loading/Normal Loading
• External loaders
• Oracle SQL Loader (any one will be covered)
• Teradata Fast load
• Informatica BDE /Introduction to Informatica-ETL  Administration

Please Visit Informatica Official Site: || Locus Academy has more than a decade experience in delivering the training/staffing on Informatica  for corporates across the globe. The participants for the training/staffing on Informatica are extremely satisfied and are able to implement the learnings in their on going projects.