Creating a generic TPT script without specifying columns

Teradata Applications

Creating a generic TPT script without specifying columns

Hi All,

Is there any method in TPT to build the script without defining the schema of the tables so that I can build one generic script and pass the tablename and databasename as parameter .

I'm trying this:

DEFINE SCHEMA Tables_SCHEMA @SourceTableName;

OR

DEFINE SCHEMA Tables_SCHEMA DELIMITED FROM TABLE @SourceTableName;

Sample job variable file

SourceTableName= 'MySourceTable'

Is this correct ?

1 REPLY
Enthusiast

Re: Creating a generic TPT script without specifying columns

Use below:

DEFINE SCHEMA SCHEMA_NAME FROM TABLE '<DataBaseName>.<Table/ViewName>';

But if you are using TPT 14.10, please be careful with Data Connector operator and Date datatype.