Posted: 15 days ago

Informatica Corporate training from Expert Trainers at Elega

Shortlist Click to Shortlist
+91 98865 41264
+91-4152 3314

Send Email Response

  • Locality: Bhattarahalli
Description for "Informatica Corporate training from Expert Trainers at Elega"

Informatica Corporate training from Expert Trainers at Elegant IT Services

After successfully completing this course, students should be able to:
Use PowerCenter 9.x Designer to build mappings that move data from sources to targets
Use PowerCenter 9.x Workflow Manager to build and run a workflow that runs a session based on a mapping
Design mappings and workflows based on business needs
Perform basic troubleshooting of PowerCenter mappings and transformations
Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 9
Introducing the need of ETL
Overview of Informatica Architecture
Client tools and Server tools and Create ,Manage and Edit Objects
Powercenter Designer
Importing Source file/Target File ( Fixed width, Delimted) and File Properties
Build mapping to load data from flat files
Powercenter Workflow Manager and Monitor
Session Properties
Creation of Workflow Task ( Session) and use it Workflow
Lab Importing File Definition Using Designer
Lab Session
Transformation Overview
Transformation data types
Source Qualifier
Source Qualifier Transformation
Source Qualifier Properties
ASource Qualifier Joins
Source Pipelines
Using Sorted Ports
Lab Session
Expression Transformation
Expression Editor
Ports ( Input , Output and Variable )
Transformation Function Overview
Lab Session
Filter Transformation
Filter Properties
Difference between Source Qualifier
Filter and Filter Transformation
Lab Session
Router Transformation
Working with Groups
Working with Ports
Connecting Router Transformations in a Mapping
Creating a Router Transformation
Difference between Router and Filter
Lab Session
Sorter and Aggregator
Sorter, Aggregator and Self Join
Sorter Transformation
Aggregator Transformation
Active and Passive Transformations
Data Concatenation
Lab Session
Rank Transformation
Ports in a Rank Transformation
Defining Groups
Creating a Rank Transformation
Lab Session
Joiner Transformation
Joins, Features and Techniques I
Joiner Transformation
Lab Session
Union Transformation
Working with Groups and Ports
Creating a Union Transformation
Using a Union Transformation in a Mapping
Debugger & Debugging Mappings
Lab Session
Lookups and Reusable Transformations
Lookup Transformation
Reusable Transformations
Lookup Caching
Lab Session
Sequence generator Transformation
Common Uses
Sequence Generator Ports
Transformation Properties
Creating a Sequence Generator
Lab Session
Load Strategies
Truncate and Load
Insert Only
Update Only
Update else Insert/Insert Else Update
Lab Session
Update Strategy and Overrides
Update Strategy Transformation
Expression Default Values
Source Qualifier Override
Target Override
Session Task Mapping Overrides
Lab Session
Working with SCD Type1 and Type2
Introducing SCDs, type 1, 2 & 3
Implementing type 1
Implementing type 2
Lab Session
Dynamic Lookup and Error Logging
Dynamic Lookup
Error Logging
Unconnected Lookup
Unconnected Lookup Transformation
Lab Session
Working with Sessions
Editing a Session
Using Pre- and Post-Session SQL Commands
Using Pre- and Post-Session OS Commands
Validating a Session
Stopping and Aborting a Session
Working with Session Parameters
Mapping Parameters and Variables in Sessions
Assigning Parameter and Variable Values in a Session
Lab Session
Workflow Variables and Tasks
Link Conditions
Workflow Variables
Assignment Task
Decision Task
Email Task
Event Raise Task
Event Wait Task
Command Task
Reusable Tasks
Reusable Session Configuration

Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph: -9886541264/87

See more ads by this user
Mark as Spam
Safety tips for buyers / sellers
Use      keys to browse Next/Prev ads
Babysitting / Nursery in Bhattarahalli :
Get similar ads More details
Locality - Bhattarahalli
Posted: 19 days ago   |   Babysitting / Nursery - Bangalore
Promote your business on
(Premium packages / Banners / Leads)
Mail us at