How to convert alpha Numeric values to alpha using functions?
Answer Posted / niraj pathak
Using convert function
Sv1=convert (0123456789,col1,"")
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the job parameters?
how to write server Routine coding?
What are the primary usages of datastage tool?
Which commands are used to import and export the datastage jobs?
Can you explain engine tier in information server?
What are iconv and oconv?
Enlist various types of routines in datastage.
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is a quality stage in datastage tool?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is usage analysis in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are the partitioning techniques available in link partitioner?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do you reject records in a transformer?