Informatica PowerExchange gives Informatica PowerCenter capability to extract and read data from mainframe by enabling it to parse formats like VSAM, IMS, IDMS, ADABAS etc. through DataMarts which work as SQL Views. It also gives functionality to do Real-Time Data Capture and Change Data Capture from Source like Mainframes, SQL Servers, Oracle Database and etc.
Informatica PowerExchange(PWX) is a tool we use to parse complex files and pull them into Designer.
Power Exchange (PWX) is comprised of 3 main components:
- Change Data Capture – Allows you to monitor and retrieve changes that have occurred to data in which you have expressed an interest.
- Data Maps – Used to access data sources like IMS databases, VSAM files and flat files.
- Personal Metadata - Allows you to browse meta data from remote databases.
Note that: PowerExchange Change Data Capture (CDC) works in conjunction with PowerCenter to capture changes to data in source tables and replicate those changes to target tables and files.
Power Exchange (PWX) CDC consists of:
- Registration group : it is to create columns and by default it will create extraction group.
- Extraction group: by default is been created after registration group and it can be smaller than Registration group and more than one (Ex: Registation group is very big and I want to make extraction group smaller to find changes easily)
- Application group: Automatically created when an Extraction group is row tested or used for changed data capture (CDC).
Components of PowerExchange(PWX) (CDC):
- PowerExchange Listener: (required) unless PowerExchange and PowerCenter integration service are installed on the same physical machine.
- PowerExchange Logger: (optional).
- PowerExchange Navigator: (required) UI tool.
