With the installation phase over, we are all set to give the PowerCenter Client tools our first try. Client tools allow us to design code, execute the code, and check the results, and they also help in configuration activities. We have four client tools available:
- PowerCenter Designer
- PowerCenter Workflow Manager
- PowerCenter Workflow Monitor
- PowerCenter Repository Manager
Each client tool allows us to do different activities that help in the complete designing and execution of code.
In this chapter, we are going to discuss the basics of the Informatica PowerCenter Designer screen. We will also have a look at the following:
- Understanding Designer Interface
- Working with Sources
- Working with Targets
- Creating source definition from the Target structure
- Feel of the data inside Repository--a preview
- Creating a database table
- Creating a mapping and using Transformation features