I am able to populate a Teradata table from Flat file using a Teradata relational database connection. However I am unable to do so with a Fast load connection for Teradata. The connection settings for the fast load utility are as follows:
Error Limit: 10000
Drop Error Tables: Yes
Max Sessions: 8
Truncate target table: Yes
Is Staged: No
Could you please let me know what could be the issue?
The data movement codepage is MS Windows Latin 1
We are not getting any error in the log files. The data is populating into the error db with a last_modified_date column data in encrypted format (non-readable)
Please check the loader log file to verify if the fast load connection is the root cause or something else. Paste the loader log file here and might suggest some options to fix it.