Courses

Back

Corporate Training Hire From Us Explore Courses

Informatica PowerExchange Certification Training

507 Ratings

Intellipaat’s Informatica PowerExchange training is an online training program led by experts from top MNCs who have 12+ years of experience. Our trainers will help you master MySQL CDC, the use of PWX, data logging, and other modules of Informatica PowerExchange through online sessions and the project work to make you a certified Informatica professional.

Key Highlights

50 Hrs Instructor Led Training
45 Hrs Self-paced Videos
100 Hrs Project & Exercises
Certification
Job Assistance
Flexible Schedule
Lifetime Free Upgrade
Mentor Support
trustpilot review 3332
sitejabber review 1429
mouthshut review 24068

Informatica PowerExchange Online Training Overview

What will you learn from Intellipaat’s Informatica PowerExchange training?

You will learn the following topics in our Informatica PowerExchange online training:

  • PowerExchange and its navigator
  • Data maps and flat files
  • SQL syntax
  • VSAM data maps
  • Integration of PowerCenter
  • Integration of PowerExchange Oracle CDC
  • Field sensitive change capture
  • PowerExchange Oracle, MySQL, and i5/OS CDC

To enroll in this Informatica PowerExchange course, you must clear the PowerCenter: Data Integration for Developers or PowerCenter: Developer, Level 1 certification.

Those professionals who have a zeal to learn and pursue a career in Informatica can enroll in this training program.

You must register for this Informatica PowerExchange online training for the reasons mentioned below:

  • In the United States alone, there are 2,800+ jobs available for Informatica professionals – Indeed
  • Informatica-certified professionals earn an average of US$100,400 per annum – PayScale
  • Top MNCs, such as JPMorgan Chase, CSG, Nokia, Deloitte, etc., are looking to hire professionals skilled in Informatica – LinkedIn
View More

Talk To Us

We are happy to help you 24/7

Career Transition

55% Average Salary Hike

$1,30,000 Highest Salary

12000+ Career Transitions

300+ Hiring Partners

Career Transition Handbook

*Past record is no guarantee of future job prospects

Course Fees

Corporate Training

  • Customized Learning
  • Enterprise grade learning management system (LMS)
  • 24x7 Support
  • Enterprise grade reporting

Contact Us

Informatica PowerExchange Course Content

Live Course

Module 1 - Introduction to PowerExchange

1.1 PowerExchange functionality
1.2 Architecture and components of PowerExchange
1.3 Features and advantages
1.4 Configuration file of DBMOVER

Download Brochure

Module 2 - PowerExchange Navigator

2.1 Navigator functions and objects
2.2 Copybooks and data maps
2.3 Personal metadata
2.4 Navigator object management
2.5 Data map creation using an EBCDIC file

Download Brochure

3.1 Developing a data map
3.2 Records in a file
3.3 Processing of the field level
3.4 Expression fields
3.5 Table definitions
3.6 Processing of arrays
3.7 Manual data maps
3.8 Using COBOL Copybook Array processing

Download Brochure

4.1 SQL WHERE Clause
4.2 DTLDESCRIBE
4.3 Personal metadata: Creating and testing
4.4 Filter records
4.5 Array handling

Download Brochure

5.1 File and field data formats
5.2 Binary data variable length
5.3 Decoding complex flat files

Download Brochure

6.1 VSAM
6.2 VSAM datasets
6.3 Access methods
6.4 Creating data maps
6.5 Performing row tests
6.6 Creating a data map using a VSAM file
6.7 Creating a data map using a multi-layout file

Download Brochure

7.1 Using PowerExchange Client for PowerCenter (PWXPC)
7.2 Advantages of PWXPC
7.3 Sources and targets of PWXPC
7.4 Integrating with PowerCenter

Download Brochure

8.1 Architecture of PowerExchange Oracle RT CDC
8.2 Application characteristics to extract changes
8.3 PWX Oracle CDC
8.4 Using PWX to register Oracle Source for CDC
8.5 Creating a registration group

Download Brochure

9.1 Creating PowerCenter workflows and mappings with PowerExchange Client
9.2 PowerCenter (PWXPC)
9.3 Restart/recovery session features using PWXPC
9.4 Remote data logging
9.5 PowerExchange CDC Publisher
9.6 Materializing target using workflow integration and PowerExchange mapping

Download Brochure

10.1 Concepts of Field Sensitive Change Capture
10.2 CI (Change Indicator) vs BI (Before Image)
10.3 Filtering unwanted change records from extraction

Download Brochure

11.1 Architecture of PowerExchange SQL Server CDC
11.2 PWX SQL Server CDC
11.3 Configuring the parameters of Consumer API (CAPI)
11.4 Enabling distribution with the console of SQL Server Management
11.5 Registering the source of SQL Server for CDC with PWX
11.6 Managing schema changes

Download Brochure

12.1 MySQL CDC
12.2 Configuration of MySQL for CDC
12.3 Configuration of PowerExchange for MySQL CDC
12.4 Building the MySQL registration group
12.5 Performing the row test
12.6 Setting up MySQL

Download Brochure

13.1 i5/OS CDC
13.2 Architecture of i5/OS PowerExchange CDC
13.3 Extraction maps
13.4 DB2 for i5/OS CDC
13.5 Task flow to extract the change data
13.6 Setting up AS400 DB2 for CDC

Download Brochure

14.1 Data map utility (DTLURDMO)
14.2 Remote program utility (DTLREXE)
14.3 Utilities of reporting
14.4 Executing, managing, and monitoring utilities

Download Brochure

15.1 Monitoring CDC processes
15.2 Heartbeat tables
15.3 PowerExchange service failover
15.4 Opportunities for performance enhancement in the PWX Oracle CDC environment

Download Brochure
View More

Informatica PowerExchange Projects

Peer Learning

Via Intellipaat PeerChat, you can interact with your peers across all classes and batches and even our alumni. Collaborate on projects, share job referrals & interview experiences, compete with the best, make new friends — the possibilities are endless and our community has something for everyone!

class-notifications
Hackathons
career-services
major-announcements
collaborative-learning

Informatica PowerExchange Certification

certificateimage Click to Zoom

How to be an Informatica professional?

To become a professional skilled in Informatica, you must enroll in our Informatica PowerExchange training course and learn all the concepts and skills in this technology. Further, you will have to work on numerous industry-based projects that will allow you to put your skills to test. Upon the completion of the course, you will receive a course completion certificate from us.

To unlock your Informatica PowerExchange certificate, you must complete the training program and successfully execute all projects and assignments included in the program.

Yes. As part of our Informatica PowerExchange training, we offer one practice test that lets you understand the types of questions that may be asked in the actual exam and the pattern of the same.

You will be able to execute all the projects included as part of Intellipaat’s PowerExchange online training under the guidance of the trainers.

View More

Informatica PowerExchange Training Reviews

( 507 )

Our Alumni Works At

Master Client Desktop

Frequently Asked Questions

Why enroll in Intellipaat’s Informatica PowerExchange training?

Informatica PowerExchange online training at Intellipaat aims to make you an Informatica professional with expert-level knowledge and skills in this domain. This is an online instructor-led training that covers all the core concepts and techniques of Informatica PowerExchange.

You will get numerous benefits through this online training program, including 24 hours of online support, lifelong free course upgrades, access to the courseware for a lifetime, and much more. During the course, you will work on real-time assignments, projects, and case studies that will help you gain hands-on experience in the domain. The placement team at Intellipaat will conduct demo interviews, prepare your resume, and more to help you land a lucrative job. Also, you will receive an industry-recognized Informatica PowerExchange training course completion certificate from us that will add value to your resume further.

Other popular courses are Salesforce, Selenium, SQL, Power BI, MSBI, Tableau, etc.

Intellipaat offers various Informatica courses such as Informatica Training, Informatica MDM, Informatica Big Data Management, and Informatica Cloud.

3 technical 1:1 sessions per month will be allowed.

Intellipaat is offering 24/7 query resolution, and you can raise a ticket with the dedicated support team at any time. You can avail of email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, 1:1 session support is provided for a period of 6 months from the start date of your course.

Intellipaat provides placement assistance to all learners who have successfully completed the training and moved to the placement pool after clearing the PRT( Placement Readiness Test) More than 500+ top MNC’s and startups hire Intellipaat learners. Our Alumni works with Google, Microsoft, Amazon, Sony, Ericsson, TCS, Mu Sigma, etc.

Apparently, no. Our job assistance is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final decision on hiring will always be based on your performance in the interview and the requirements of the recruiter.

View More