Join this group to access featured content and participate in discussions related to DMX.

142 Members
Join Us!

TPT Stream - Modify .tbuild

Hi,

We are required to add below parameters to TPT stream operator while loading to teradata table.

               DEFINE OPERATOR LOAD_OPERATOR

               TYPE STREAM

               SCHEMA TTU_TEST_SCHEMA

               ATTRIBUTES(

                              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
TYPE STREAM
SCHEMA *
ATTRIBUTES
(
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'
);

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –

To access Syncsort Knowledge Base, visit:

My Support