Transformations in TPT

Tools & Utilities

Transformations in TPT

Can any one give an example of how to do a transformation in TPT. e.g The source table has three columns ColA, ColB and ColC (all three are strings) whereas the destination table has two DestCol1 and DestCol2 (also strings). Where DestCol2 is ColB + ColC. How would you actually do this using TPT.

Thanks
2 REPLIES
Enthusiast

Re: Transformations in TPT

Hi mutador,

I'm looking for the same thing.

There are no example on TPT's typical use.

Is there someone who can give us an example which illustrate the use of TPT in a typical project ? Producer, Consomer and transform data.

I've found an very interesting explanation and example on TPT with this website but you have to pay for that :

http://my.safaribooksonline.com/book/databases/content-management-systems/9780983336341/chapter-7-te...

Teradata Employee

Re: Transformations in TPT

Please look at the TPT Reference and/or User Guide at the syntax for the CASE statement support.

I think you will be able to see how this is possible in the TPT script language.

-- SteveF