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
Highlight all the modes that are present under Confidence Level.
What are the newly developed features of Teradata?
Explain and compare pros and cons of snow flake schemas?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the available join types in teradata?
Explain BYNET.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the difference between union and union all in teradata?
Explain the advantages of partitioned primary index in a query?
What are default access rights in teradata? What explicit right can be given to a user?
What is the function of parser component in teradata?
What is meant by a dispatcher?
Explain vproc in teradata?
Discuss the advantages of using partitioned primary index in a query?
Syntax for case when statement?