I am trying to load a file which has 2181224338 records to a Teradata table using TPT Script. The Data Connector attributes are as below and I am using LOAD operator. Version of TTU is 14.10.00.11.
What is the reason for this? If I remove the attribute SkipRowsEveryFile (default is N) then all the records are loaded
Did you check the table to see how many rows are actually in the table?
When you do a SELECT COUNT(*), the default result is an integer value.
To get the true value you will have to CAST the result to a BIGINT (if your database version supoprts that data type) or DECIMAL.
Yes Steve. I checked the record count as select cast(count(1) as bigint) and the value is still 2147483646
We have located the source of the bug and will fix in the near future.
The workaround (as you well know), if you only have a single file, then do not set SkipRowsEveryFile to 'Y'.
We have fixed the bug.
The fix will be available in the next set of 14.10, 15.0 and 15.10 efixes.
Dates for those releases have not yet been announced.