Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert alpha Numeric values to alpha using functions?
- 1 Answers
- 3096 Views
- CTS, I also Faced
- E-Mail Answers
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
how to add a new records into source?
Explain how a source file is populated?
What are the benefits of datastage?
What is "fatal error/rdbms code 3996" error?
How to find value from a column in a dataset?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the precedence of stage variables,derivations, and constraints?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Describe link sort?
What are routines in datastage?
What is usage analysis in datastage?
How do you import and export data into datastage?
