Course Overview
This Boot Camp for Developers Informatica PowerCenter 9.6.x course teaches the fundamentals of the Informatica PowerCenter 9.6.x 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 PowerCenter
developer.
What you’ll learn
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
Requirements
- Some Informatica PowerCenter experience
Target audiences
- Developers with no previous PowerCenter or ETL experience
Curriculum
- 1 Section
- 4 Lessons
- 4 Days
Expand all sectionsCollapse all sections
- Topics4
- 1.1Day One Course Introduction Course Objectives Introduction to Informatica PowerCenter Components & Architecture Basic Concepts Live Demo: creating and debugging a mapping Designer Overview Interface Folders Workspaces Concepts Sources and Targets Mappings Student Lab 1 Source and Target Definitions, Simple Mapping Transformation Objects in Depth I Transformations Objects Overview Source Qualifier Expression Transformation Aggregator Transformation Filter Transformation Student Lab 2 Expression, Aggregator, and Filter Transformations
- 1.2Day Two Review Quiz Working with the Designer Layout Link Path Compare Objects Working with Transformations Using the Debugger Debugging process and strategies Discard Data Option Flow Control Breakpoints Evaluate expressions Working with Flat Files and Joiner Transformation Importing and editing flat file sources/targets Flat file data-types Joiner Transformation Student Lab 3 Joining flat file and relational data Transformation Objects in Depth II Lookup Transformation Stored Procedure Transformation Rank Transformation Using built-in functions Student Lab 4 Lookup and Rank Transformations Local Variables Overview Using local Variables Port evaluation Transformation Objects in Depth III Sorter Transformation Router Transformation Designer Tips Auto Link Propagate Attributes Student Lab 5 Local variables, Sorter, and Router Transformations
- 1.3Day Three Review Quiz Sharing and Reusing Designer Objects Reusable transformations Working with shortcuts Mapplets Student Lab 6 Mapplets User Defined Functions Overview Setup Transformation Objects in Depth IV Union Normalizer Student Lab 7 Normalizer and User Defined Functions Transformation Objects in Depth V Java Transformation SQL Transformation HTTP Transformation Transaction Control Slowly-Changing Dimensions Student Lab 8 Type 1 – Slowly Changing Dimension
- 1.4Day Four Review Quiz Workflow Manager Overview Workspaces Simple Workflow Overview Creating Session setup Workflow Monitor Interface Gantt Chart View Task View Controlling workflows and tasks Viewing logs & session properties Workflow Error Handling Overview Sessions Link Conditions Student Lab 9 Simple Workflow and Error Handling Complex Workflows Overview Scheduler Reusability Wizard Workflow Tasks in Depth Email Task Command Task Decision Task Timer Task Event Raise & Wait Task Control Task Worklets Student Lab 10 Complex Workflow Parameters & Variables Overview In Mappings In Sessions In Workflow Integration Service Student Lab 11 Mapping Parameters and Variables
Instructor
