Is there any limitation on reading the number of fields in a delimited file by using the DATACONNECTOR PRODUCER. We have a file which has 7000 fields per record and we only need to load 1000 of those into multiple table. When I define the schema with more than 2000 fields for Data Connector as below it gives me an error that error reading the schema. My other option is to split the file first but want to avoid two step approach.
DESCRIPTION 'Load a Teradata table from a file' (
DEFINE SCHEMA Schema_l_test1 (
We should (in theory) be able to read in that many fields, and I will definitely have someone look into this.
What version of TPT are you running?
Can you also post a screenshot of the console output you get when you run the job?
Most likely because Teradata only supports 2048 columns.
(My other questions were not answered.)