Interested to Buy Any Domain ? << Click Here >> for more details...
CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"
- 11 Answers
- 16519 Views
- I also Faced
- E-Mail Answers
Answer Posted / bilas
use TRANSLATE function
select
translate ('323-237-2323','0123456789-', '0123456789')
from table_name;
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are the types of Data Warehouse applications?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is partitioning? Explain different types of partitioning?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
What are the different Lookup methods used in Informatica?
what is Forward,Reverse and Re_engineering?
what is a worklet?
Explain the key challenges that you face while performing etl testing.
What are the three tiers in etl?
How to fine tune mappings?
Which transformation we use to convert 'NA' to 'Not Available'
How to increase performance without changing anything in mapping.( In prod)
how do u identify the changed records in operational data?
what are the session parameters? How do u set them?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
