This course extends the skills and knowledge of experienced Powercenter developers. Reviewing advanced topics with extended labs covering PowerCenter connection architecture, high availability, and session and workflow recovery. Informatica PowerCenter is a collection of thick client workbench tools that Developers can use to create, execute, monitor and schedule ETL processes.TAKE THIS COURSE
- 21 hours of Instructor led learning
- 16 hours of High Quality e-Training
- 5 hours of industry projects
- Hands on projects execution with LVTLab
- Expert Assistant Premium Support
This course extends the skills and knowledge of experienced Powercenter developers. Reviewing advanced topics with extended labs covering PowerCenter connection architecture, high availability, and session and workflow recovery
After successfully completing this course, students should be able to do following tasks
- Use Informatica Support to resolve questions and problems with PowerCenter 9.x
- Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target, transforming it as necessary
- Use PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets
- Perform error handling/trapping using PowerCenter mappings
- Use PowerCenter 9.x Workflow Manager to build and run a workflow which executes a sessions associated with a mapping
- Design and build simple mappings and workflows based on essential business needs Perform basic troubleshooting using PowerCenter logs and debugger
Introduction to the Informatica PowerCenter Developer Track 2 Course
- Describe the Components of the PowerCenter 9 Architecture and define key terms.
- Describe Power Center’s optional and built-in high availability features
- Describe User Defined Function to Create Entity Types
- Describe & implement advanced functions
- Describe the use of the normalizer and aggregator transformation to normalize and de-normalize date
- Describe the use of the Stored Procedure transformation in a mapping or mapplet.
- Describe the uses of the SQL Transform
- Describe Source based & Target based transaction controls with and without high availability option
- Describe the use of PowerCenter constraint-based loading in databases with referential integrity constraints
- Describe the use of the transaction control transformation for data-driven transaction control.
- Describe control when data is committed to disk or the target database
- Describe workflow and task recovery with and without the high availability option.
- Recover tasks and workflows that stop, abort or terminate.
- Explain and use PowerCenter’s built-in recovery capabilities.
- Explain the user-designed recovery techniques.
- Design error handling strategies appropriate for the intended purpose of a workflow.
- Use pmcmd to start, restart and recover workflows.
- Use pmrep for object export, mass validation, object import, back-up and EBF migration of a unit or work.
- Describe Performance counters.
- Describe busy percentages & how they help in bottleneck isolation.
- Describe thread utilization to identify a target bottleneck.
- Describe thread utilization to identify a transformation bottleneck.
- Describe thread utilization to identify a source bottleneck.
- Describe types of target bottlenecks: database, network, disk & PowerCenter.
- Describe 3 alternatives to the update-else-insert scenario.
- Describe how transaction control impacts performance.
- Describe Types of source bottlenecks: database, network, disk & PowerCenter.
- Describe tune the line sequential buffer.
- Describe external loader effects on target bottlenecks
- Explain types of data type conversion: port-to-port, expression-to-port and explicit.
- Identify which transformations increase or decrease the number of rows.
- Explain the performance implications of the stored procedure vs. the SQL transformation.
- Describe data caching & RAM memory optimization techniques to improve session performance
- Describe DTM buffer pool optimization.
- Describe how pipelines & partitions affect performance.
- Describe 3 options for merging partitions: sequential, concurrent & file list.
- Describe how partitioning affects the DTM buffer pool.
You should enrolled for the courses to get access to the lab documents
You can enroll for the Masters Program through our website. You can make an online payment using any of the following options:
1.Visa debit/credit card
2.American Express and Diners Club cards
Once the online payment is done, you will automatically receive a payment receipt and access information, via email.
1.Access to e-learning content for all the courses included in the learning path
2.Access to exclusive forums, moderated by faculty and industry experts
3.Hands-on Project Execution with LVTLab
4.Earn Masters Certification upon completing the Program requirements of the learning path
Yes, you can cancel your enrolment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.
Your course completion certificate will be auto generated in the LMS once you meet all of the criteria below:
Completion of at least 85% of the eLearning course
Submission of project per course requirements.
Successfully meeting the project evaluation criteria set by our experts
Once you register with us for a course by paying the course fee, you can have 24/7 access to the e-learning content on our website. An automated course purchase confirmation mail sent by us, will guide you through the process.
Please raise a request through Help & Support. You can also chat with us to get an instant solution.
Yes. We do offer a money-back guarantee for many of our training programs. You can refer to the Refund Policy and raise refund requests via our Help and Support portal.
Contact us using the form on the LVTLABS website, or select the Live Chat link. Our customer service representatives will be able to give you more details.