Teradata connector BULK load issue
Posted: Sat Apr 04, 2015 10:23 am
Hi All,
I have an issue with teradata bulk load. The job will load data from dataset to teradata database (teradata connector used).
When I run the job with BULk load the data is loading to WORK table but not to the main table.
The log showing 0 records inserted in main table and no abort except the information message Exit code: 4. The job completed successfully without any warnings.
I could able to load the table successfully with the Immediate method.
Can any one suggest me what is wrong with BULK load.
Job Flow: Dataset to teradata connector. Connectior properties are below .
Table action= Append
Write mode= Insert
ACCESS_METHOD = Bulk
LOAD_TYPE = Load
LOG_TABLE = CLNT_MSTR
ERROR_LIMIT = 1
MIN_SESSIONS = 2
MAX_SESSIONS = 6
TENACITY_HOURS = 1
SYNC_TIMEOUT = 999
SYNC_TABLE = LOG_D1
TENACITY_SLEEP = 3
ARRAY_SIZE = 200
CLIENT_CHARSET = UTF8
PARALLEL_SYNC = 1
NLS_MAP = UTF8
RECORD_COUNT = 2000
Bulk access: Start mode=Cleanup and cleanup mode=drop
Sync table action:Replace
Sync table cleanup: keep
Thanks in advance,
Ureddy
I have an issue with teradata bulk load. The job will load data from dataset to teradata database (teradata connector used).
When I run the job with BULk load the data is loading to WORK table but not to the main table.
The log showing 0 records inserted in main table and no abort except the information message Exit code: 4. The job completed successfully without any warnings.
I could able to load the table successfully with the Immediate method.
Can any one suggest me what is wrong with BULK load.
Job Flow: Dataset to teradata connector. Connectior properties are below .
Table action= Append
Write mode= Insert
ACCESS_METHOD = Bulk
LOAD_TYPE = Load
LOG_TABLE = CLNT_MSTR
ERROR_LIMIT = 1
MIN_SESSIONS = 2
MAX_SESSIONS = 6
TENACITY_HOURS = 1
SYNC_TIMEOUT = 999
SYNC_TABLE = LOG_D1
TENACITY_SLEEP = 3
ARRAY_SIZE = 200
CLIENT_CHARSET = UTF8
PARALLEL_SYNC = 1
NLS_MAP = UTF8
RECORD_COUNT = 2000
Bulk access: Start mode=Cleanup and cleanup mode=drop
Sync table action:Replace
Sync table cleanup: keep
Thanks in advance,
Ureddy