Database Reference
In-Depth Information
you have a primary key or other constraints in your target table. As our target
table has keys defined, we are using a normal property.
Scroll through the properties and make changes if required. If we use
File
as
Target
, we
need to define the location of the file in your system under the
Output
file directory.
Also, specify the name of the file under
Output
filename if you use flat file as target, as
shown in the following screenshot:
If you are using the lookup transformation in your mapping, you will need to define the
file path or table connection for lookup. Click on
Lookup
under
Transformations
and
define the
Connection
details, as shown in the upcoming screenshot.