Monday, September 1, 2014

TRANSFORMER STAGE USING PADSTRING FUNCTION

TRANSFORMER STAGE USING PADSTRING FUNCTION
Padstring is a function used to padding the data after the string.

If we have a data as below


Table_1

e_id,e_name
10,emy
20,july
30,revol
40,wagon

(Remember to give gap between the words to understand the Padstring function)


Take Job Design as

Seq.File------------Tx--------------D.s


Read and load the data in sequential file.

Now Go to the Transformer stage, here in required column derivation write your

expression as below

padstring(e_name,'@',5) for e_name

Here '@' is called padding you want to get after the data

5 is the padlength Now click ok


Give file name at the target file

Compile and Run the Job

No comments: