Database Reference
In-Depth Information
Summary
We started the chapter with the basic components of the PowerCenter Designer screen, that
is, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, and
Mapping Designer. You then learned to work on different types of sources, which included
flat files (delimited files and fixed-width files) and relational databases. Similarly, we
worked on different types of targets. We also worked on the import and create functionalit-
ies of sources and targets. Later in the chapter, you saw how to preview the data. The last
and most important aspect that you learned in this chapter was how to create mappings us-
ing sources and targets.
The Informatica PowerCenter Designer screen, of course, cannot be that simple. Moving
ahead, in the next chapter, we will see the advanced concepts of the designer screen. There
are a lot of high-level functionalities that are added in the designer window to help better
and faster processing.
In the next chapter, you will see how to process the data by managing the constraints in the
database. You will also see the utility to debug the mapping, which will help in finding any
errors, and will study the concept of the reusable functionality of transformations and map-
ping.
