View detailed fastload output?

Teradata Studio
Teradata Employee

View detailed fastload output?

Any way to see the detailed job output from a Smart Loader fast load job?  Would be real if I could see the generated fastload script and the full verbose log output

4 REPLIES 4
Highlighted
Teradata Employee

Re: View detailed fastload output?

Smart Loader doesn't launch FastLoad or even TPTAPI, it uses "JDBC Fastload" feature. Is there specific information you are looking for?

Teradata Employee

Re: View detailed fastload output?

thanks Fred - didn't know this, saw "fastload" in the manual and assumed it was the same thing.  ultimately what i was hoping to do was use Smart Loader to build a fastload script for me so I could use it's auto-identified data type recommendations.  wish we had a tool that would read a CSV and build an appropriate TPT input schema for me....

Teradata Employee

Re: View detailed fastload output?

Not quite the same thing, but you can tell TPT to build a delimited schema based on the columns in a target table, e.g.

...  FROM OPERATOR( $FILE_READER( DELIMITED 'myTargetTable') ) ...

See "Advanced Scripting Strategies" section of the TPT User Guide manual.

Teradata Employee

Re: View detailed fastload output?

that is awesome to know, and actually solves my current problem.  Thanks so much Fred.