Description

Course Content Informatica ETL

1: Introduction to PowerCenter

•  How PowerCenter performs data integration
• Advantages of code-free and SQL-free development and then  Informatica architecture
• PowerCenter components and applications therefore PowerCenter object types

2: Folders, Sources, and Targets

•  PowerCenter folder types
•  Folder best practices
• Source definition types and methods of creation moreover Target definition types and methods of creation
• Benefits of object shortcuts

3: Design Objects

• Fundamental mapping components
• Transformation types and then 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 moreover Multi-return lookups
• Bypassing transformations

5: Relational Lookups

• How to create a lookup on relational data
• Understanding lookup connectivity
• Port default values and then Variable ports
• Refreshing mapping metadata

6: Database Joins in PowerCenter

•  Getting the database to join data
• Reusable transformations and then Target Load Plan
•  Multi-pipeline mappings
•  Workflow link conditions

7: Workflow Logic

•  Using Session pre-defined variables
•  Using Decision Tasks and  then 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 therefore,  Understanding built-in connection variables
•  Creating and using Worklets
•  Timer Tasks and then 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 and then  creating sources from targets
•  Switching between transformations for efficient editing
•  Source Qualifier overrides to filer data at a relational source