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
- Rank, Joiner
- Built-In Functions
- User-Defined Functions
- 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
- In mappings
- In sessions and workflows
- Parameter files