Thursday, November 1, 2012
Teradata interview questions
How to extract numbers from strings in Teradata Sql?
how can we analyze the locks ?
If the script is aborted. why it is aborted and how can you identify ?
how do you handle ET and UV errors ?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
If RDBMS is halted what will you do ?
we have the num like this +91666666666......i want to remove 91 and i want lo load remaining data to the target table..
whinch function we can use in teradata?
what is meant by Hot amp?
What is meant by MATCHTAG in multiload utility?
Subscribe to:
Post Comments (Atom)
This comment has been removed by a blog administrator.
ReplyDeleteHow to extract numbers from strings in Teradata Sql?
ReplyDeleteSEL
CAST(otranslate('str55555ingd4w5i6th8digit', 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ!@#$%^&*()', '') AS DECIMAL(18,0)) ;
--555554568
abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
ReplyDeleteselect translate(Name,'',';') as Name
from tablename;
TrainingsIn.com : All Trainings in one place, Hyderabad Training Institutes, Bangalore, Chennai, Pune, Delhi, Mumbai Training Institutes
ReplyDeleteThanks for a marvelous posting!the information about SAP Training Institute with Live project I quite enjoyed reading it, you’re a great author.
ReplyDeleteI will remember to bookmark your blog and will often come back sometime soon.
I want to encourage you continue your great work, have a nice weekend!
http://erp2sapconsultant.blogspot.in/
Good Posts. Keep posting, all your posts are very helpful.
ReplyDeleteMicrosoft Dynamics AX Training | Teradata Training Bangalore