All Forums Tools
mutator 4 posts Joined 10/07
27 Jun 2008
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

vincent91 14 posts Joined 02/10
16 Feb 2012

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-teradata-parallel-transport-tpt/a_sample_bteq_script_for_compa#X2ludGVybmFsX0ZsYXNoUmVhZGVyP3htbGlkPTk3ODA5ODMzMzYzNDEvMjQ4

 

 

feinholz 1234 posts Joined 05/08
16 Feb 2012

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

You must sign in to leave a comment.