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
how do u handle performance issues in Informatica . where can u monitor the performance ?
how would u estimate the size of Aggregator transform data and index cache?
what is granularity in Data ware House?
When do we go for the tools in the market?
what is pmrep command?
Do we need an etl tool?
what is dynamic insert?
what happens if the info.server doesn't find the session parameter in the parameter file?
how do use session mapping parameters ?(in which transformation)
What are the key benefits of ETL Testing?
when will use SQL override in a lookup transformation?
What are dimensions?
What are the various tools used in etl?
what are Lookup caches options? Including persistent caches.
State the differences between shortcut and reusable transformation