If you have Numerical+Characters data in the source, how will you load only Character data to the target? Which functions will you use in Transformer stage?

raj

• Nov 8th, 2012

Example : raje123ndh456ar

Code
convert(0123456789,,raje123ndh456ar) = rajendhar 

now it is converted to character string and we can load only character.

Vinay Sharma

• Oct 4th, 2012

Use alpha function.
Exp-->alpha(123vinay567)
Ans-->vinay

i thing this is your requeriment..

Answer Question  Select Best Answer