Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Description

This step writes input data to a text file in the form of a set of SQL statements.  The SQL is generated in the dialect of the selected database.

General Tab

Option

Description

Step Name

Name of the step; the name has to be unique in a single transformation.

Connection

  • Connection : select the database for which you want to generate the SQL.  The information in the connection is used to select the appropriate dialect.
  • Target schema : the schema of the table to generate the SQL for
  • Target table : the name of the table to generate the SQL for

Output file

  • Add create table statement : check this if you want the "CREATE TABLE" statement to be included in the generated SQL
  • Add truncate table statement: check this if the table is expected to exist and you want the "TRUNCATE TABLE" statement to be included in the generated SQL. Note that this could also be a "DELETE FROM" statement, depending on the database dialect.
  • Start new line for each statement : Enable this to increase the readability of the file
  • Filename : the filename (without file extension)
  • Create parent folder : if you want the parent folder of the specified file to be created if it doesn't exist already.
  • Do not open create at start : if you don't want an empty file in case there are no input rows
  • Extension : the required file extension ("sql" by default)
  • Include stepnr in filename : includes the step number (when running in multiple copies) in the output filename
  • Include date in filename : includes the date in the output filename with format yyyyMMdd (20081231)
  • Include time in filename : includes the date in the output filename with format HHmmss (235959)
  • Append : append the generated SQL to the existing file
  • Split every ... rows : limits the size of a single file by starting a new one every ... rows.
  • Show filenames : hit this button to see the complete filename after assembly of the various parts (filename, extension, stepnr, date and time)
  • Add File to result: Adds the filenames written to the result of this transformation.  A unique list is being kept in memory that can be used in the next job entry in a job, for example in another transformation.

Content Tab

Option

Description

Date format

Allows you to specify the date format.

Encoding

Allows you to specify the text file encoding

  • No labels