Page 1 of 1
Getting fastLoad script from Teradata connector
Posted: Mon Jun 13, 2016 10:51 pm
by abhilashnair
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?
Posted: Tue Jun 14, 2016 5:38 pm
by ray.wurlod
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.
Posted: Wed Jun 15, 2016 4:28 am
by vinothkumar
You can, may be if you get a chance to work with Teradata enterprise stages.
Posted: Wed Jun 15, 2016 11:44 pm
by abhilashnair
Ok Ray. Is this script stored somewhere or redirected to a log file, where I can find it?
Posted: Thu Jun 16, 2016 12:28 am
by ray.wurlod
No Teradata at my current site; others will need to answer that question.
Posted: Thu Jun 16, 2016 5:47 am
by daignault
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