Duration: Hours

Training Mode: Online




    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


    There are no reviews yet.

    Be the first to review “Informatica ETL”

    Your email address will not be published. Required fields are marked *