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"
Answer Posted / kkr
select replace ('323-237-2323','-') from dual
select substr('abc@co.com',-7) from dual
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is data modeling?
what is the meaning of upgradation of Repository?
In Which Transformation We Can Use Having Clause In Informatica?
where is the cache (lookup, index) created and how can you see it.
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is partitioning? Explain different types of partitioning?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What is full load & incremental or refresh load?
what is a worklet?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Which transformation we use to convert 'NA' to 'Not Available'
how do u set partition points in the mapping?
how to connect to a flatfile through ftp in informatica
Explain what is etl process? How many steps etl contains explain with example?
what is data modeling?