How to convert alpha Numeric values to alpha using functions?
- 1 Answers
- 2086 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 do y read Sequential file from job control?
Can you implement SCD2 using join, transformer and funnel stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are sequencers?
What are the types of hashed files in data stage
How many types of views are there in a datastage director?
What is the purpose of interprocessor stage in server jobs?
Is it possible to query a hash file?
Why we use surrogate key?
What all are the different way to run a job?
Explain the situation where you have applied SCD in your project?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Why do we use link partitioner and link collector in datastage?
Why do you need stage variables?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
