Curriculum
- 1 Section
- 16 Lessons
- 4 Days
Expand all sectionsCollapse all sections
- Topics16
- 1.1Introduction Course Objectives Introduction to Informatica PowerCenter Components & Architecture Basic Concepts Live Demo: creating and debugging a mapping.
- 1.2Main Concepts: Sources and Targets Mappings Exercise #1: Source and Target Definitions, Simple Mapping
- 1.3Transformation Objects: Expression, Aggregator & Filter Transformations Objects Overview Source Qualifier Expression Transformation Aggregator Transformation Filter Transformation Exercise # 2
- 1.4Working with the Designer Layout, Link Path, Auto link & Propagating Attributes Comparing Objects Working with Transformations
- 1.5Debugger Debugging process and strategies Discard Data Option Flow Control & Breakpoints Evaluate expressions
- 1.6Flat Files & Joiner Transformation Importing and editing flat file sources/targets Flat files: Fixed Width, Delimited Joiner Transformation Exercise # 3: Joining flat file and relational data
- 1.7Transformations: Lookup & Rank Lookup Transformation Active & Passive Connected & Unconnected Rank Transformation Using built-in functions Exercise # 4: Lookup and Rank Transformations
- 1.8Workflow Manager & Monitor Overview Creating a Workflow Session setup & Parameters Workflow Interface Gantt Chart View, Task View Controlling workflows and tasks Viewing logs & session properties
- 1.9Workflow Error Handling Overview in Sessions and Link Conditions Exercise # 5: Simple Workflow and Error Handling
- 1.10Local variables, Sorter & Router Transformations Overview Using local Variables: Interactive Demo Port evaluation Router Transformation Exercise # 6
- 1.11Parameters & Variables Overview Usage In Mappings, Sessions, and Workflows Integration Service Parameters Exercise # 7: Mapping Parameters and Variables
- 1.12Reusability: All Objects & Mapplets Reusable transformations Working with shortcuts Mapplets Exercise # 8: Mapplets
- 1.13UDF: User Defined Functions Overview Sharing UDFs
- 1.14Transformations: Union & Normalizer Union Normalizer Exercise # 9: Normalizer and User Defined Functions
- 1.15Slowly Changing Dimensions Overview of Type 1, 2, 3 & 6 Exercise # 10: Type 1 – Slowly Changing Dimension
- 1.16Advanced Workflows & Tasks Overview, Scheduler & Reusability Wizards Email Task, Command Task, Decision Task, Timer Task Event Raise, Event Wait, Control Task Worklets Exercise # 11: Advanced Workflows
Main Concepts: Sources and Targets Mappings Exercise #1: Source and Target Definitions, Simple Mapping
Next