Data Target: Other page

Admin |

ETL > ETL Domains > Data target: Others link > Fields definition

Note: if the ETL domain is locked, the window will open in read-only mode.

Purpose of the page

This window allows you to define the target destinations on which data can be loaded

Actions on this page

Element	Description
	This filters the data shown on the page.
	This adds a row in order to insert a new field
	This duplicates the selected row with all the information inserted, except for the code.
	Deletes the element contained in the selected row.
	Enables/Disables the grid modify function. This allows you to change the characteristics of the selected elements directly in the table, and to hide the configuration tabs.
	Enables multi-row selection to allow mass changes.
	Selects the columns to be shown/hidden in the table and those to be locked when scrolling the table.
	Exports the data in Excel format so they can be edited and reimported into CCH Tagetik.
	Imports data from a previously prepared Excel file.

Attributes tab

Please find below the most important fields.

Field	Description
Code	Data target: Others code to be used in the loading task. Mandatory
Description	- Data target: Others description. Mandatory
Type	type of Data target: Others onto which data must be loaded. Mandatory
Table name / File name	mandatory. Depending on the selected type, this may indicate one of the following options: - custom table name if the type relates to a database - file name if the type relates to a file. If the type relates to a system file, in the file creation step, it will process the name defined both with reference to a loading task and with the default extension. This is all to prevent file overwriting problems if the same routine contains two loading tasks that use the same Data target: Others. For example, if the defined name is “FILE” for a Data target: Others whose type is Text Delimited, and the loading task to which the Data target: Others is associated has 10 as its sort position, the file created will be named “FILE10.txt”. - to tell the system to remove the sort position, simply add the # character to the end of the name. For example, if the defined name is “FILE#”, the created file will be named “FILE.txt”. - to tell the system to remove the sort position and not apply the default extension, simply add the * character to the end of the name. For example, if the defined name is “FILE.csv*”, the created file will be named “FILE.csv”. Note: The ETL’s dynamic syntax can be used to define a parametric name (see ETL syntax).
Detail	includes the Fields definition link which opens the fields definition window where you can indicate, for each field of the custom destination, whether, during the loading step, it must be populated from the values present in a field of the staging table related to a dimension of the ETL domain or from an individual value (defined manually or calculated automatically by the system).
Databases	Active if the selected type relates to a database: - Create table: if active, this option tells the system to create the table defined using the fields definition on first execution (if it does not already exist); - Other database connection: indicates the JDBC connection to connect to a secondary database (selected in the type field) - Delete table link: allows you to delete, directly from the application, the custom table defined in the Table name/File name field;
Files	- a section that can be used if the selected type relates to a file, which contains: - Excel area name/Xml tag name: if the type relates to an Excel (xls), Excel (xlsx) or Xml file, this allows you to indicate: - for Excel files, the name to be given to the sheet and the data area; - for xml files, the name to be given to the tag related to the individual record. if the value is not specified, the value defined in the Table name/File name field will be used. - Add header: if active, this option tells the system to add a record containing the column headers as the first row of the created file; - Separator: if the type relates to a Text delimited file, this allows you to specify the character used to separate information items contained in the file columns; - Charset: if defined, this indicates the character coding with which the file must be created. If it is not defined, the system will use the default; - Export file in zip format: if active, this option tells the system to create the file in zip format. This option is particularly useful to avoid “Out of Memory” problems if there is a lot of data to be loaded;
Use Trim function on data	if active, this tells the system to remove all spaces present in the text or at the end of the value to be loaded.
Use quote in the fields name	if active, this tells the system to delimit the names of the tables and fields with the " character, both in reading data to be loaded and in creating and populating the custom table (if the type is related to a database). The purpose is to preserve the case of the defined names and to allow you to use names containing characters that would otherwise be prohibited, like spaces.