Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and ..

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

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and ..

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

Post New Answer

More Teradata Interview Questions

which option is used to restart the fastexport script ?

2 Answers   TCS,

Explain fastload in teradata?

0 Answers  

What is TPD?

0 Answers  

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

List the logical and conditional operators that are used with teradata along with their meanings?

0 Answers  

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

How to relege locks in fastload and multiload? example?

4 Answers   IBM,

What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

Explain how spool space is used.

0 Answers  

For more Teradata Interview Questions Click Here
Categories