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 |
State the difference between an operational datastage and a data warehouse?
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?
What is the purpose of pivot stage?
What are the types of containers in datastage?
What are the functionalities of link partitioner and link collector?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
How many areas for files does datastage have?
how to validate the jobs
What is container and then types?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
How to convert table data into xml file using xml output stage? please explain step by step;
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?