Description
Course Content
1: Introduction to PowerCenter
• How PowerCenter performs data integration
• Advantages of code-free and SQL-free development
• Informatica architecture
• PowerCenter components and applications
• PowerCenter object types
2: Folders, Sources, and Targets
• PowerCenter folder types
• Folder best practices
• Source definition types and methods of creation
• Target definition types and methods of creation
• Benefits of object shortcuts
3: Design Objects
• Fundamental mapping components
• Transformation types
• Mapping types
• PowerCenter expressions and port types
• Filtering records
4: File Lookups
• Fundamentals of the Lookup transformation
• How to create a lookup on file data
• Joining heterogeneous data
• Multi-return lookups
• Bypassing transformations
5: Relational Lookups
• How to create a lookup on relational data
• Understanding lookup connectivity
• Port default values
• Variable ports
• Refreshing mapping metadata
6: Database Joins in PowerCenter
• Getting the database to join data
• Reusable transformations
• Target Load Plan
• Multi-pipeline mappings
• Workflow link conditions
7: Workflow Logic
• Using Session pre-defined variables
• Using Decision Tasks
• Using Email Tasks
• Sending email from within a Session
8: Merging, Routing, and Sorting Data
• Merging mapping pipelines
• Removing duplicate records
• Classifying data with the Router transformation
• Renaming Source Qualifier ports
9: Command Tasks
• Running command line statements within a Workflow
• Lookup caching properties
• Persistent lookup caches
• Aliasing a lookup port
10: Debugging
• When to use the debugger utility
• Launching and configuring the debugger
• Debugger features and techniques
11: Parameterization
• How and when to parameterize values and properties
• Using a parameter file
• When to use an unconnected lookup
• Using a Sequence Generator transformation
12: Updating Database Tables
• How to update and delete from relational database tables
• Perform insert-else-update logic with the Update Strategy transformation
• Understanding built-in connection variables
• Creating and using Worklets
• Timer Tasks
• Control Tasks
13: Mapplets
• Creating and using Mapplets
• Mapplet types and limitations
• Aggregator transformations
14: Mapping Design Workshop
• Students independently design and test their own transformations based on supplied business rules.
15: Addendum
• Autolink
• Changing the order of ports
• Using a file list
• Creating sources from targets
• Switching between transformations for efficient editing
• Source Qualifier overrides to filer data at a relational source
Reviews
There are no reviews yet.