You need to specify the data target(s) to which your data will be copied. You can choose to use an existing table as your target, or create a new target.
Note: For new target tables, column descriptions are included in the synonym. The descriptions may come from the source table or from a source transform.
A data target can be a relational data target, non-relational data target, or a flat file. In some cases, relational targets can provide the ability to write to remote tables. For more information see, Reviewing Your Data Targets.
Note: This is only supported for existing targets. The name of the remote server must match the real server name of the subserver. This option should only be used for small data volumes. For large volumes, you should install the DataMigrator server on the platform where the data will be loaded.
You can load your data into as many as fifteen tables in a single data flow.
After selecting a data target, you can do the following:
The following data target types can be used:
|
|
|
A target object appears in the workspace.
The attributes of the target open in a new pane.
Note: Only data targets types that are configured on the server and supported by DataMigrator will appear.
If you have chosen a FOCUS/FDS, XFOCUS, flat file, delimited flat file, or formatted file, when you press the Enter key, the data file name will automatically change to match the synonym name. This can be changed.
Note: If you do not provide a synonym name, it will default to target01 for the first new target, target02 for the second, and so on.
New targets will automatically contain the same columns that were selected in the SQL Object. For information about managing columns, see Selecting Columns.
Note: If the columns selected from the source have descriptions, these descriptions will be included with the corresponding columns in a new target.
For relational database targets, you can specify connection (if applicable), application directory, synonym, and table name. For details, see How to Set Options for Relational Targets.
For FOCUS/FDS or XFOCUS files you can specify synonym application directory, synonym, data application directory, and dataset (name of file). For details, see How to Set Options for FOCUS/FDS or XFOCUS Targets. Synonym names for FOCUS/FDS files cannot be longer than eight characters.
For flat files you can specify synonym application directory, synonym, data application directory, and dataset (name of flat file). For details, see How to Set Options for Flat, Delimited Flat, Formatted, and XML File Targets.
For formatted files you can specify format, synonym application directory, synonym, data application directory, and dataset (name of formatted file). For details, see How to Set Options for Flat, Delimited Flat, Formatted, and XML File Targets.
Note: On IBM z/OS to create a file in HFS (hierarchical file system) enter the name, to create a dataset enter the name as
//’qualif.tablename.type’
where:
Is the fully qualified location.
Should match the synonym name.
Is DATA or FOCUS, by convention.
When creating a new target table, the name of the synonym that describes that table is normally entered as text and saved with the flow. This procedure should be used when you desire to specify the name of the target table dynamically when the flow is run.
A target object appears in the workspace.
The attributes of the target open in a new pane.
Note: Only data targets types that are configured on the server and supported by DataMigrator will appear.
MS SQL Server table target:
Delimited Flat File target:
A dialog box opens requesting a value for the variable.
To submit a data flow with a variable name, or to schedule such a flow, the value for the variable must be assigned. This can be done with a process flow that calls the data flow.
The data flow workspace opens.
Right-click the Start icon, drag a line connecting to the data flow icon, and release. Then double-click the data flow icon to open its properties.
The Parameter Editor opens.
The Drill Down Parameter Editor dialog opens.
In the DMC, drag a synonym object from the navigation pane to the right of the SQL Object in the workspace.
or
Right-click in the workspace to the right of the SQL Object, select Add Target and then Existing. Open an Application Directory, select an object, and click Select.
The data target is automatically connected to the SQL Object.
With the data flow open in the workspace:
The Select Source dialog box opens.
iWay Software |