Database Reference
In-Depth Information
A feel of the data inside the repository - a preview
Now that you have learned to use sources and targets in PowerCenter, we will start using
these sources and targets in mappings. As mentioned earlier, in the PowerCenter Designer
we only deal with the metadata of sources and targets; we do have an option to preview the
data of the source and target, which we imported by providing the path/connection for files
or tables. This gives us an option to understand the data clearly before we move ahead with
the next step.
Previewing the source data - flat files
Perform the following steps to preview the data in the source:
1. Drag-and-drop the source from the navigator section to Source Analyzer. We are
using
EMP_FILE
as our reference to preview data.
2. Right-click on the source definition and click on
Preview Data
.
