Course Overview
This is THE boot camp that will provide developers with a solid foundation to start the journey with the Informatica platform. The foundation class teaches the fundamentals of the Informatica Data Integration (ETL) using PowerCenter 10.5x.
The boot camp is delivered through a variety of lectures, demos, and numerous hands-on lab exercises covering real business use cases. Attendees will gain a clear understanding of the product and acquire a solid foundation that will transform them into successful PowerCenter developers in 4 days!
This foundation class is a great entry point to other Informatica products like IDQ and IDMC (Cloud).
What you’ll learn
Upon completion of the Informatica PowerCenter v10.5x Foundation Boot Camp for Developers course, students will be able to:
- Create and configure an Informatica folder that would allow shortcuts
- Reverse-engineer Source & Target tables from existing databases/schemas.
- Create source and target Flat files delimited and fixed width
- Create target tables by generating DDLs and executing them on the Database through an ODBC connection
- Build and debug simple and complex mappings.
- Create and run simple and medium-complexity workflows.
- Run a workflow and monitor its run through the Workflow Monitor
- Observe and analyze Log files for workflow and mapping session tasks.
Target audiences
- Developers
Curriculum
- 1 Section
- 16 Lessons
- 4 Days
- 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
