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
What is a quality stage in datastage tool?
Is it possible to query a hash file?
why do u need the IOS upgradation in a FC switch
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Define APT_CONFIG in Datastage?
Can you explain players in datastage?
Is possible to create skid in dim,fact tables?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Differentiate between Join, Merge and Lookup stage?
how to add a new records into source?
In Datastage, how you can fix the truncated data error?
project Steps,hits, Project level HArd things,Solved methods?
What is a merge?
Can you explain kafka connector?
What is staging variable?