Database Reference
In-Depth Information
Before we proceed further, we need to make some points clear:
• As we have used flat file as a source, the Informatica PowerCenter wizard gener-
ates the target as a file as well. We cannot maintain SCD on files, so make sure
you change the target type to the database. We will be changing this to the
Oracle
table as a reference. You can do this in the Target Designer. Drag the
target (
EMPLOYEE_SCD1
) created by the wizard in the Target Designer, double-
click to open the properties, and change the database type of
Oracle
. This will
change the type of target from the file to Oracle. Once you modify the target table
to the Oracle database, the mapping will look like the following figure: