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 |
I have a few records just I want to store data in to targets cycling way how?
what is executable in DataStage?
source contains 2 columns comes to target 4 columns how
how to sort two columns in single job in datastage.
Enlist various types of routines in datastage.
how can we extract data with out having any common column
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
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what are the types of nodes
1.what is materialized data? 2.how to view the materialized data?