Datamart task

A datamart task reads data from a source (XML, CSV, SQL query, etc), applies a transformation, if necessary, and then stores the result at a specified destination (table, XML,CSV, etc).

Execution tab

Specify values for the following fields on the Execution tab:

Field Description
Source

Choose from the following:

  • XML
  • CSV
  • SQL data set
  • standard log file
  • Excel file
Transformation The XSL transformation performs the conversion from one format to the other
Destination

Choose from the following:

  • a table
  • an XML file
  • a CSV file
  • an Excel file

Settings tab

There are three sections on the Settings tab: Source, Transformation, and Destination. The fields available in each of these sections depend on the source and destination you choose on the Execution tab.

Section Type of source/destination Field and Description
Source XML file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
  • Delete after import: The file is deleted after the task ends.
CSV file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
  • Encoding: List of character encodings.
  • Import the file: Choose from the following
    • From the beginning
    • From the line
    • To the end
    • To the line
  • Separation character: The separation character used in the CSV file.
  • Text delimiter: The delimiter text used in the CSV file.
  • Delete after import: The file is deleted after the task ends.
Query SQL query: SQL type of dataset.
Std Log file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
  • Encoding: List of character encodings.
  • Delete after import: The file is deleted after the task ends.
Excel file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
  • Delete after import: The file is deleted after the task ends.
Transformation  
  • None : no transformation available
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • XSL File: The XSL file that facilitates the conversion from one format to the other.
Destination Table
  • World: The database connection where the table will be created or updated.
  • Table: The name of the table to be populated with the source data.
  • Catalog: The name of the database catalog.
  • Schema: The name of the database schema.
  • Insert type: Choose from Update-Insert, Insert, and Replace.
  • Clear first: If this option is checked, the table is emptied before inserting the new data.
  • Create table if needed: The table is created if it does not exist.
  • Delete type : Choose from Delete and Truncate.
  • Commit type: Choose from Line by line(Auto commit), Global commit, and Number of lines before a commit.
  • Batch execution: Choose from Deactivated, Global batch, and Number of lines in a batch.
XML file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
CSV file
  • Directory: The location of the file. The directory must be created in Administration > Folder.
  • File: The name of the source file included in the Directory specified above. The file can have personalized fields.
  • Encoding: List of character encodings.
  • Import the file: Choose from the following:
    • From the beginning
    • From the line
    • To the end
    • To the line
  • Separation character: The separation character used in the CSV file.
  • Export the headings: The headers from the CSV file are also exported.
Excel file Directory: The location of the file. The directory must be created in Administration > Folder.

File: The name of the source file included in the Directory specified above. The file can have personalized fields.

Related Links