Join this group to access featured content and participate in discussions related to DMX.
We are required to add below parameters to TPT stream operator while loading to teradata table.
DEFINE OPERATOR LOAD_OPERATOR
VARCHAR PrivateLogName = 'LOAD_OPERATOR_LOG',
VARCHAR PackMaximum = 'No',
INTEGER Pack = 2400,
I am not sure where I can mention these parameters in a DMExpress copy task. Can someone please let me know if is it possible to mention these parameters in the TPT Stream connection in DMExpress task? If Yes, where can we mention them. If someone is sure that one cannot exclusively specify these, then too please let me know.
I could see the below block getting generated internally by dmexpress task while using tpt stream with YES for 'Generate utility job script'
DEFINE OPERATOR DMX_STREAM_OP
TargetTable = '"ABC_STG_DB"."ABC_STG"',
LogTable = '"ABC_WORK"."t20180102204702_338475592002"',
ErrorTable = '"ABC_WORK"."t20180102204702_338472053314"',
ErrorLimit = 1,
UserName = @UserName,
UserPassword = @UserPassword,
TdpId = 'xxxxxx.xxxx.xxxxx'