Getting fastLoad script from Teradata connector

abhilashnair · Post by **abhilashnair** » Mon Jun 13, 2016 10:51 pm

I have a parallel job that loads data from sequential file to Teradata Database using Teradata Connector stage in Bulk/Load mode.

Is there a way to get the SQL query that DataStage generates to load the data in the table?

ray.wurlod · Post by **ray.wurlod** » Tue Jun 14, 2016 5:38 pm

As a general observation, bulk loaders (for any database) do not use SQL.

Instead, they use a load script particular to the database. So this would be a FastLoad script in the case of Teradata.

vinothkumar · Post by **vinothkumar** » Wed Jun 15, 2016 4:28 am

You can, may be if you get a chance to work with Teradata enterprise stages.

abhilashnair · Post by **abhilashnair** » Wed Jun 15, 2016 11:44 pm

Ok Ray. Is this script stored somewhere or redirected to a log file, where I can find it?

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2016 12:28 am

No Teradata at my current site; others will need to answer that question.

Post by **daignault** » Thu Jun 16, 2016 5:47 am

The Enterprise stage will present the generated BTEQ script for review. We have an enhancement request with IBM that the connector stage be enhanced to support the same functionality as Enterprise stage.

The issue is the binaries used are different between Connector and Enterprise stage. Enterprise will use BTEQ and TPUMP Connector stages use TPT which is a combined operator. Teradata left certain functionality out of TPT.

Regards