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.
Boot Camp for Developers Informatica PowerCenter 9.6.x
Duration
4 Days
Course
INPC-155
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Boot Camp for Developers Informatica PowerCenter 9.6.x course teaches the fundamentals of the Informatica PowerCenter 9.6x platform 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 PowerCenterdeveloper.
Objectives
Upon completion of the Boot Camp for Developers Informatica PowerCenter 9.6.x course, students will be able to:
- Understand PowerCenter Components & Architecture
- Work with the Designer
- Use the Debugger
- Work with Flat Files and Joiner Transformation
- Understand workspaces and workflows
- Identify Parameters & Variables
Audience
- Developers with no previous PowerCenter or ETL experience
Prerequisites
- Some Informatica PowerCenter experience
Topics
Day One
Course Introduction
Live Demo: creating and debugging a mapping
Designer Overview
Concepts
Student Lab 1
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
-
Advanced Boot Camp for Developers Informatica PowerCenter 9.6.x
INPC-160- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,400.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.