i want anser this question empno,ename,sal 12,mmm_ww,200
13,nnn_xx,300 14,bbb_qq,400 which stages are take which
types of logicks are doing pls help me i don't need "_"ex
nnnxx this type i want
Answer Posted / roshan nayak
To achieve this use "Convert" function.
ex - Convert('+-_()?','',NullToEmpty(Input_link))
this will convert "_" or any of the specify special
char-rector with empty string.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
how can we create rank using datastage?what is the meaning of rank?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What can we do with datastage director?
Which algorithm you used for your hashfile?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How can we improve the performance in datastage?
What is the difference between operational data stage (ods) and data warehouse?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
How rejected rows are managed in datastage?
Could anyone give brief explanation bout datastage admin
describe the Steps to confiure a Qlogic switch
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what are the errors,warnings in datastage
How many types of stage?