ETLActivity

An ETL activity.

Properties

args : identifierList

ETLActivity arguments: arg1 arg2 ... argN.

These are arguments that the ETL activity expects. They can be passed in by SysETLActivity'invoke... or by setting them using the ETL Activity Tool.

Valid values based on“token”.
(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*\s+)*(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*)?	Each element in the list must begin with a letter or underscore. Elements are space delimited.

description : string

Description of this ETLActivity.

layout : string

GUI layout data.

privileged : boolean

True to execute the ETL activity in privileged mode (without security restrictions).

variables : identifierList

ETLActivity variables: var1 var2 ... varN.

Variables can be used to pass information from step to step or control functionality. If a variable is used in an ETL pipeline, the pipeline may not be capable of validating completely until runtime. In this case, a debug log message will be generated.

Valid values based on“token”.
(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*\s+)*(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*)?	Each element in the list must begin with a letter or underscore. Elements are space delimited.

Content

• Choice of:

  • Script [1..1]

  • Goto [1..1]

  • ETLPipeline [1..1] - Pipelines gather and group cursors and commands together into related units, becoming the defining blocks of your ETL activities.

  • TruncateTable [1..1] - An ETL TruncateTable command.

  • CopyTable [1..1] - An ETL CopyTable command.

  • TryCatch [1..1]

  • Join [1..1]

  • any [1..1]