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