Interested to Buy Any Domain ? << Click Here >> for more details...
Frnds....
i have one doubt
we have the num like this +913757575......i want to remove
91 and i want lo load remaining data to the target table..
whinch function we can use in teradata?????
Plz let me know..
thanks in advance
- 2 Answers
- 6594 Views
- I also Faced
- E-Mail Answers
Answer Posted / hanumanth
Hi we can use substr function in teradata
like
sel c1,substr(c1,4,13)from table.
like this we can load
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
When tpump is used instead of multiload?
What do you mean by teradata intelliflex?
Differentiate primary key and partition key?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is upsert statement in teradata?
Mention a few of the ETL tools that come under Teradata.
how many modules are there in telecome domain?how to explain the architecture?
Steps to create a data model?
What do you mean by teradata intellicloud?
What are the available primary index types?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is real time and near real time data warehousing?
What are the available join types in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the scenarios in which full table scans occurs?
