Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert alpha Numeric values to alpha using functions?
- 1 Answers
- 3071 Views
- CTS, I also Faced
- E-Mail Answers
Answer / niraj pathak
Using convert function
Sv1=convert (0123456789,col1,"")
| Is This Answer Correct ? | 0 Yes | 0 No |
Can aggregator and transformer stages use to sort the data? How ?
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?
State the difference between an operational datastage and a data warehouse?
how can find maximum salary by using Remove duplicate stage?
how can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
What is a merge?
what is hash file
Where do the datastage jobs get stored?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is apt_config in datastage?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
Teradata 
