Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert alpha Numeric values to alpha using functions?
- 1 Answers
- 3024 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
What is the purpose of pivot stage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the difference between orabulk and bcp stages?
What is the difference between Datastage 7.5 and 7.0?
If you want to use a same piece of code in different jobs, how will you achieve this?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is data partitioning?
Explain the situation where you have applied SCD in your project?
what is the difference between == and eq in UNIX shell scripting?
What are the areas of application?
Which algorithm you used for your hashfile?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is a merge?
