Informatica

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Informatica is the world’s leading independent provider of data integration software and services. Informatica’s solutions empower organizations with timely, relevant and trustworthy data to help them build a stronger competitive advantage.The Informatica domain is the primary unit for management and administration within PowerCenter. The Service Manager runs on an Informatica domain. The Service Manager supports the domain and the application services. Application services represent server-based functionality. The domain supports PowerCenter and Informatica application services. PowerCenter application services include the PowerCenter Repository Service, PowerCenter Integration Service, Web Services Hub, and SAP BW Service. Informatica Services include the Data Integration Service, Model Repository Service, and the Analyst Service.

At the end of the training, participants will be able to:

Pre-requisite

Attendees should have experience of Data processing.

Duarion

5 days

Course Outline

  • Course Objectives
  • Introduction to Informatica PowerCenter
  • Components & Architecture
  • Interface
  • Tools
  • Mappings
  • Sources and Targets
  • Transformations Objects
  • Transformation Objects In Depth I
  • Source Qualifier
  • Expression
  • Filter
  • Aggregator
  • Target Instance
  • Lookup
  • Importing & editing flat file sources & targets
  • Flat file data-types
  • Debugging process and strategies
  • Breakpoints, evaluate expressions
  • Documenting objects
  • Context Sensitive Help, Autolink, Link Path
  • Stored Procedure, Router, Sorter
  • Using local variables
  • Port evaluation
  • Built-In Functions
  • User-Defined Functions
Accordion Content
  • Reusable transformations
  • Working with shortcuts

Union, Normalizer, Java Transformation, SQL Transformation, HTTP Transformation, Transaction Control

  • Designer: Foreign Key Relationships
  • Transformation Objects In Depth V
  • Update Strategy, Sequence Generator
Workflow Manager
  •  
  • Menus & tools
  • 5 steps to creating a workflow
  • Session properties
  • Interface
  • Controlling workflows and tasks
  • Viewing logs & session properties
  • Gantt Chart View & Task View
  • Command, Email, Decision, Timer, Control, Event Raise & Wait
Accordion Content
  • In mappings
  • In sessions and workflows
  • Parameter files

Reviews