Transformations in BTEQ vs TPT

Tools

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.

1 REPLY
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.