How to convert alpha Numeric values to alpha using functions?



How to convert alpha Numeric values to alpha using functions?..

Answer / niraj pathak

Using convert function
Sv1=convert (0123456789,col1,"")

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is meta stage?

0 Answers  


Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,


how do u reduce warnings

1 Answers   CGI,


souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  


Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,


what is the main difference between sorragate key n primary key in one word

2 Answers  


where the log files or tables can store in DS?

2 Answers   IBM,


what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,


What is a quality stage?

1 Answers  


Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,


Which warehouse using in your datawarehouse

0 Answers   IBM,


Is it possible to query a hash file?

0 Answers   IBM,


Categories