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
- 17004 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
Use trim(columnname,'_','a') to remove the '-' values from
the columns
2) use field function: field(columnname,'@'2) to get the
company.com
Thanks
Kumar
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What is a lookup table in etl?
what is pmrep command?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
how do u set partition points in the mapping?
explain the methodology of Data Warehousing?(Polaries)
what is the meaning of upgradation of Repository?
how many maximum session supports to multiload in teradata ??
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
how to load the data to fact table?
Explain the use lookup tables and Aggregate tables?
what are the production issues in datastage?
How to fine tune mappings?
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.
what are the concerns of OLTP and DSS systems?
What is the difference between Data Warehousing and Data Mining?
