Friday, April 29, 2011
Transformer Stage using Stripwhitespaces Function
Some times we get the data as below
20, j ul y
30,re v o l
40,w a go n
Take Job Design as
Se.File ------ Tx------D.s
Read and load the data in Sequential file stage
Go to Transformer stage
Here, we use stripwhitespaces function in the required column derivation.
You can write expression as below
Stripwhitespaces(e_name) for e_name
Compile and Run the data
You will get the data after removal of all the spaces between the characters,
before and after spaces also.
Read more about Transformer Stage with example
If you know Better Answer for Above Question Comment below to Answer.
Change Capture Stage is used to capture the changes between two sources based on the change code. Change Code is the Code generated w...
Some times we get the data as below Customers 1,tommy,2000 2,sam,2300 3,margaret,2000 4,pinky,1900 5,sheela,2000 Take Job Design...