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
Answers were Sorted based on User's Feedback
Answer / tdguy
Substr function would be suitable for this requirement.
Even if the column type is integer, substr can be used.
Implicit casting takes place. But trim function should be
used to avoid leading spaces.
example: column name - phoneno - type integer
value: - 913757575
SEL SUBSTR(TRIM(PHONENO),3,7) FROM TABLE;
Above sql will give you the correct output.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
Difference between star and snowflake schemas?
Describe primary index in teradata. And what are the available primary index types?
What is the purpose of indexes?
What are the available join types in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain fastload in teradata?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the main components of teradata system?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
what is the default character set in teradata,,?
Explain teradata vs. Redshift?