title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Informatica PowerCenter 10.x Boot Camp for Developers
Duration
4 Days
Course
INPC-165
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Informatica PowerCenter 10.x Boot Camp for Developers course teaches the fundamentals through lecture and numerous hands-on lab exercises. Students will gain a clear understanding of the product and acquire a solid foundation needed to make them a successful PowerCenter developer.Objectives
Audience
- Developers with no previous PowerCenter or ETL experience
Topics
Day one
Course Introduction
Live Demo: creating and debugging a mapping
Designer Overview
Concepts
Student Lab1
Transformation Objects in Depth I
Student Lab 2
Day Two
Review Quiz
Working with the Designer
Using the Debugger
Working with Flat Files and Joiner Transformation
Student Lab 3
Transformation Objects in Depth II
Student Lab 4
Local Variables
Transformation Objects in Depth III
Designer Tips
Student Lab 5
Day Three
Review Quiz
Sharing and Reusing Designer Objects
Student Lab 6
User Defined Functions
Transformation Objects in Depth IV
Student Lab 7
Transformation Objects in Depth V
Slowly-Changing Dimensions
Student Lab 8
Day Four
Review Quiz
Workflow Manager
Simple Workflow
Workflow Monitor
Workflow Error Handling
Student Lab 9
Complex Workflows
Workflow Tasks in Depth
Student Lab 10
Parameters & Variables
Student Lab 11
- Course Objectives
- Introduction to Informatica PowerCenter
- Components & Architecture
- Basic Concepts
- Interface
- Folders
- Workspaces
- Sources and Targets
- Mappings
- Source and Target Definitions, Simple Mapping
- Transformations Objects Overview
- Source Qualifier
- Expression Transformation
- Aggregator Transformation
- Filter Transformation
- Expression, Aggregator, and Filter Transformations
- Layout
- Link Path
- Compare Objects
- Working with Transformations
- Debugging process and strategies
- Discard Data Option
- Flow Control
- Breakpoints
- Evaluate expressions
- Importing and editing flat file sources/targets
- Flat file data-types
- Joiner Transformation
- Joining flat file and relational data
- Lookup Transformation
- Stored Procedure Transformation
- Rank Transformation
- Using built-in functions
- Lookup and Rank Transformations
- Overview
- Using local Variables
- Port evaluation
- Sorter Transformation
- Router Transformation
- Auto Link
- Propagate Attributes
- Local variables, Sorter, and Router Transformations
- Reusable transformations
- Working with shortcuts
- Mapplets
- Mapplets
- Overview
- Setup
- Union
- Normalizer
- Normalizer and User Defined Functions
- Java Transformation
- SQL Transformation
- HTTP Transformation
- Transaction Control
- Type 1 – Slowly Changing Dimension
- Overview
- Workspaces
- Overview
- Creating
- Session setup
- Interface
- Gantt Chart View
- Task View
- Controlling workflows and tasks
- Viewing logs & session properties
- Overview
- Sessions
- Link Conditions
- Simple Workflow and Error Handling
- Overview
- Scheduler
- Reusability
- Wizard
- Email Task
- Command Task
- Decision Task
- Timer Task
- Event Raise & Wait Task
- Control Task
- Worklets
- Complex Workflow
- Overview
- In Mappings
- In Sessions
- In Workflow
- Integration Service
- Mapping Parameters and Variables
Related Courses
-
PowerCenter 8.6/9.1 Web Services
INPC-125- Duration: 2 Days
- Delivery Format: Classroom Training, Online Training
- Price: 1,600.00 USD
-
Boot Camp for Developers Informatica PowerCenter 8.6/9.1
INPC-130- Duration: 4 Days
- Delivery Format: Classroom Training
- Price: 3,200.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.