Pre-declared parameters

Data Query

Attribute	Type	Description
table	#Table	The #Table to generate the data query for.
allColumns	boolean	A flag for whether the query is for all columns or only the columns specified in the table definition.
caseStyle	String	The style of casing ('actual', 'lower', 'upper').
encapsulate	boolean	A flag for whether to add encapsulation to names.
generateSurrogates	boolean	A flag for whether to generate the query with surrogate key columns.
allowDataTransformations	boolean	A flag for whether to generate the query with any data transformations specified.
additionalColumns	List	A list of String containing additional values for the Select's column clause.
additionalWhereClauses	List	A list of String containing additional values for the Select's where clause.
retainWhereClause	boolean	A flag for whether to retain the where clause from a previous generated data query.

Attribute	Type	Description
table	#Table	The #Table to generate the dw query for.
caseStyle	String	The style of casing ('actual', 'lower', 'upper').
encapsulate	boolean	A flag for whether to add encapsulation to names.
ECS_AO	String	The encapsulation character for opening alias.
ECS_AC	String	The encapsulation character for closing alias.
ECS_SO	String	The encapsulation character for opening schema. The value of this variable will be '[' for DW queries generated in the RED Export category.
ECS_SC	String	The encapsulation character for closing schema. The value of this variable will be ']' for DW queries generated in the RED Export category.
ECS_TO	String	The encapsulation character for opening table. The value of this variable will be '[' for DW queries generated in the RED Export category.
ECS_TC	String	The encapsulation character for closing table. The value of this variable will be ']' for DW queries generated in the RED Export category.
ECS_CO	String	The encapsulation character for opening column.
ECS_CC	String	The encapsulation character for closing column.
forcedSchema	String	The value of this variable will be 'TABLEOWNER' for DW queries generated in the RED Export category. In other categories the value will be 'null'.
retainWhereClause	boolean	A flag for whether to retain the where clause from a previous generated dw query.
copyQueryWhereClause	boolean	A flag for whether to copy the where clause from a previous generated data query.

Attribute	Type	Description
table	#Table	One of the #Table to generate DDL for.
tables	List	A list of #Table containing the tables to generate DDL for.
caseStyle	String	The style of casing ('actual', 'lower', 'upper').
encapsulate	boolean	A flag for whether to add encapsulation to names.
targetLocations	List	A list of String containing the target locations to filter on. Can contain 'null' for no target location. The list if empty to signify no filtering of target locations.

Attribute	Type	Description
table	#Table	The #Table to generate the ddl view query for.
queryStyle	String	The type of query to generate, either a data ('data') query or a data warehouse ('dw') query.
encapsulate	boolean	A flag for whether to add encapsulation to names.
caseStyle	String	The style of casing ('actual', 'lower', 'upper').
allowDataTransformations	boolean	A flag for whether to generate the query with any data transformations specified.
ECS_AO	String	The encapsulation character for opening alias.
ECS_AC	String	The encapsulation character for closing alias.
ECS_SO	String	The encapsulation character for opening schema.
ECS_SC	String	The encapsulation character for closing schema.
ECS_TO	String	The encapsulation character for opening table.
ECS_TC	String	The encapsulation character for closing table.
ECS_CO	String	The encapsulation character for opening column.
ECS_CC	String	The encapsulation character for closing column.

Attribute	Type	Description
table	#Table	The #Table to generate the denormalized query for.
encapsulate	boolean	A flag for whether to add encapsulation to names.
caseStyle	String	The style of casing ('actual', 'lower', 'upper').
hasDimDate	boolean	A flag for whether the source contains a table named 'dim_date'.
queryColumnNames	Map	A map of column keys to alias names to be used instead of the current column name.