Every operator attribute is exposed to tdload.
However, TrimColumns is only for the file reader. Not for the file writer.
Fred, I am testing my TPT script on AWS teradata Instance and it has 2 node, 6AMP system.
its taking 16 mins to export 1.6 GB of data. I tried to set MaxSessions to 6 each for source and target.
Can it be increased or I will get same output
If you are using the Export operator for extracting the data out of the database, then you cannot increase the number of sessions.
The Export operator supports a max of 1 session per available AMP.
And for loading, the Load and Update operators also only support a max of 1 session per available AMP.
I was able to export 2.5 GB in less than 5 minutes. And I have defined export instance as 4 and maxSessions as 24.
But can not make it more faster
Also, We have tables FallBack protected having size 30GB. Its not even starting to run.
There are few more questions I have.
1) Should we use Bteq in place of TDload for smaller tables.
2) Decimal 56.90 is stored as 56.9 in files and I need to have zero at the end too for data validation.Is it possible. Also, if there is any digit such as 56.62, it is coming fine in Tdload as well as Fast export. Please assist