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
What are the components used in smp and massively parallel processing (mpp) machines?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How to Extract data from multiple legacy systems?
What is meant by Teradata Gateway?
Describe the set operators in teradata.
What is the difference between fastload and multiload? Which one is faster?
What are the updated features of teradata?
What is meant by a Parsing Engine?
What is the purpose of upsert command?
What are the advantages of teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the things to be considered while creating secondary index?
if collect stats but it show low confidence why?
Define views in teradata with syntax.
What are the main components of teradata system?