|
Name |
Description |
|
AWSPerformCOPYFromS3 |
Indicates whether COPY command will be issued when importing records |
|
AWSRedshiftDistributionStyle |
If set, DISTSTYLE is used for all RPI-generated tables. Values are 0=AUTO, 1=EVEN, 2=KEY, ALL=3 |
|
AWSRetainCOPYGeneratedFilesInS3 |
Indicates whether files (*.gz) generated for COPY bulk import will be retained |
|
AWSSourceS3BucketName |
Fully qualified name of AWS S3 external content provider and bucket name to use |
|
AzureSQLDWDistributionType |
If set, offer history tables will be created either ROUND_ROBIN=0 or HASH=1 |
|
AzureSQLDWDropStatisticsOnTempTables |
If set, statistics will be dropped on all temp tables created |
|
DatabaseInsertBatchLimit |
Insert batch size limit used by specific databases when inserting and updating rows |
|
DatabaseSpecificRetryableErrorEnabled |
Controls if query execution can be retried when 'Invalid object name' database error has occurred |
|
DB2RunStatsEnabled |
If set, enables RUNSTATS on all generated tables and indexes |
|
DisableDatabaseObjectQualification |
Indicates whether to fully qualify database object names |
|
GoogleBigQueryUseInformationSchema |
If set, the INFORMATION_SCHEMA will be used to retrieve tables and views |
|
OracleAudienceTempTablesIndexDisabled |
If set, disables indexing on all audience temp tables |
|
OracleDegreeOfParallelism |
Indicates the DOP for single database or cluster configurations |
|
OracleDMLSessionParallelismEnabled |
If set, enables DML session parallelism |
|
OracleOptimizerDynamicSamplingLevel |
Overrides the level [0 - 8] of optimizer_dynamic_sampling configuration at a session level |
|
OracleRunTableStats |
If set, run statistics on tables |
|
OracleTempTablesParallelismEnabled |
If set, enables parallelism on all temporary tables |
|
OracleTempTablesPKConstraintDisabled |
If set, disables the primary key constraint on all Dataflow_XXX temp tables |
|
OracleUseDirectPathInsert |
If set, direct-path hint will be appended into INSERT-SELECT queries on all audience temp tables |
|
OracleUseHashEnabled |
If set, enables USE_HASH hint on all sub-queries |
|
PostgresUseReplicaIdentity |
If set, REPLICA IDENTITY is used to create all RPI-generated audience tables |
|
SQLServerDisableRowLockHint |
If set, ROWLOCK will be disabled from INSERT, DELETE and UPDATE queries on all RPI-generated tables |
|
SQLServerIndexTempTables |
Controls if indexes are created on temporary audience tables |
|
SQLServerUseColumnStoreIndexTempTables |
Controls if clustered column store indexes are created on temporary audience tables |
|
SQLServerUseCountBig |
If set, queries will use the Count_Big statement instead of Count |
|
SQLServerUseCreateTableInsert |
If set, CREATE TABLE and INSERT is used to create all RPI-generated audience tables |
|
SQLServerUseIdentityTempTables |
If set, identity is used to generate unique id for temporary audience tables |
|
SQLServerUseSelectIntoOverUpdate |
If set, SELECT INTO query is used to update records from a temporary audience table |
|
SQLServerUseTabLockHint |
If set, TABLOCK hint will be appended into INSERT-INTO queries on all RPI-generated temporary tables |
|
SQLServerUseTempFlagTables |
Uses intermediate tables in SQL Server when creating attribute flag fields |
|
TeradataIndexTempTables |
Controls if indexes are created on temporary audience Teradata tables |
|
TeradataUsePrimaryIndex |
If set, PRIMARY INDEX is used for all RPI-generated tables. Otherwise, PRIMARY KEY will be used |
|
TeradataUseTableCharacterSet |
RPI-generated tables character set; 1 = UNICODE, 2 = LATIN, or 0 = Don't specify the constraint |
|
YellowbrickDistributionType |
If set, DISTRIBUTE is used for all RPI-generated tables. Values are 0=COLUMN, 1=REPLICATE, 2=RANDOM |