Training Overview
Applicable for software versions 9.5 through 10. x. Provides professionals with the skills & knowledge necessary to design, build, test, & maintain real-world data integration systems with PowerCenter's workbench tools. Professionals will learn how to create & combine PowerCenter objects such as source & target definitions, data transformations, mappings, sessions, & workflows in order to accomplish their project goals while using the best-practice methodology.
Audience Profile
Developer
Learning Objectives
After successfully completing this training, professionals should be able to:
- Use the PowerCenter Designer interface to design data transformations.
- Manage a variety of source & target definitions.
- Filter, join, aggregate, categorize, merge, & apply expression logic to data without writing SQL.
- Monitor & repair PowerCenter Sessions & Workflows.
- Troubleshoot mapping problems with the debugger.
- Leverage object reusability (build-once, use everywhere)
- Benefit from specific Agile Data Integration best practice techniques.
Content Outline
- How PowerCenter performs data integration
- Advantages of code-free & SQL-free development
- Informatica architecture
- PowerCenter components & applications
- PowerCenter object types
- PowerCenter folder types
- Folder best practices
- Source definition types & methods of creation
- Target definition types & methods of creation
- Benefits of object shortcuts
- Fundamental mapping components
- Transformation types
- Mapping types
- PowerCenter expressions & port types
- Filtering records
- Fundamentals of the Lookup transformation
- How to create a lookup on file data
- Joining heterogeneous data
- Multi-return lookups
- Bypassing transformations
- How to create a lookup on relational data
- Understanding lookup connectivity
- Port default values
- Variable ports
- Refreshing mapping metadata
- Getting the database to join the data
- Reusable transformations
- Target Load Plan
- Multi-pipeline mappings
- Workflow link conditions
- Using Session pre-defined variables
- Using Decision Tasks
- Using Email Tasks
- Sending emails from within a Session
- Merging mapping pipelines
- Removing duplicate records
- Classifying data with the Router transformation
- Renaming Source Qualifier ports
- Running command-line statements within a Workflow
- Lookup caching properties
- Persistent lookup caches
- Aliasing a lookup port
- When to use the debugger utility
- Launching & configuring the debugger
- Debugger features & techniques
- How & when to parameterize values & properties
- Using a parameter file
- When to use an unconnected lookup
- Using a Sequence Generator transformation
- How to update & delete from relational database tables
- Perform insert-else-update logic with the Update Strategy transformation
- Understanding built-in connection variables
- Creating & using Worklets
- Timer Tasks
- Control Tasks
- Creating & using Mapplets
- Mapplet types & limitations
- Aggregator transformations
Professionals independently design & test their own transformations based on supplied business rules.
- 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
FAQs
A: By data integration, businesses combine their data residing in sources which provides a user with a real-time view of the business performance.
A: Transformation jobs for preparing data, provisioning jobs for transmission of data & hybrid jobs are major types of data integration jobs.
A: Data integration administrator performs multiple jobs like Scheduling & executing the batch jobs, Configuring, Adapters configuration & managing them, Repository usage, Job Server configuration starting & stopping the real-time services, Access Server configuration, Batch job publishing & Real-time services publishing through web services.
A: Radiant has highly intensive selection criteria for Technology Trainers & Consultants who deliver training programs. Our trainers & consultants undergo rigorous technical & behavioral interviews & assessment processes before they are onboarded in the company.
Our Technology experts/trainers & consultants carry deep-dive knowledge in the technical subject & are certified by the OEM.
Our training programs are practically oriented with 70% – 80% hands-on training technology tools. Our training program focuses on one-on-one interaction with each participant, the latest content in the curriculum, real-time projects & case studies during the training program.
Our faculty will provide you the knowledge of each training from the fundamental level in an easy way & you are free to ask your doubts any time from your respective faculty.
Our trainers have the patience & ability to explain difficult concepts in a simplistic way with depth & width of knowledge.
To ensure quality learning, we provide support sessions even after the training program.
A: Radiant Techlearning offers a training program on weekdays, weekends & a combination of weekdays & weekends. You can always choose the schedule that best suits your need.
A: We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, due to some contingency, if you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or any commercial use.
A: Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant hand-on-practice.
Participants can easily access these labs over Cloud with the help of a remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world & in any time zone.