Transformations in BTEQ vs TPT

Tools & Utilities

Transformations in BTEQ vs TPT

Hi All,

Does someone have a chart that describes the pros and cons of performing Transformations in BTEQ vs TPT? To be more precise, I am looking for what can be and what cannot be done wrt transformation in BTEQ and TPT.

This is kind of urgent, so any help would be greatly appreciated.

Thank you.

Teradata Employee

Re: Transformations in BTEQ vs TPT

BTEQ doesn't perform transformations, though you can submit SQL to transform already-loaded data inside the database.

TPT provides limited transformations via expressions in the SELECT statement of the APPLY clause (and like BTEQ can also submit SQL for in-database transformations, via the DDL operator). You could also code a custom "filter operator" to perform more complex transformations within TPT.