Hi Frnds this que is recently asked at IBM
there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.
Can any one help
thanks in advance
Answer Posted / ashutosh gautam
Use DIGITS("aa6588fhfhf") in transform it will return only
digit as 6588.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain the advantages of partitioned primary index in a query?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is meant by a Highest Cost Plan?
Explain and compare pros and cons of start schemas?
What is collect statistics?
Explain fastload in teradata?
What is spool space? Why do you get spool space errors?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
any one answer me how they can analyzing the project using data ware housing?
Difference between inner join and outer join?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Explain the meaning of Amp?
What are the different functions performed in development phase?
What are the various etl tools in the market?