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 / again kuttu!!
select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
how would u estimate the size of Aggregator transform data and index cache?
what is the use of structures?how many nodes can u create in a structure?
what is the difference steps for data modeling?
Mention few test cases and explain them?
Which transformation we use to convert 'NA' to 'Not Available'
What are the key benefits of ETL Testing?
where we cannot use sorter Transformation. if we use then we will not get correct data?
list and discuss two approaches for updation of target table in Informatica and how they are different.
What are various etl tools in the market?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What is virtual Data Warehousing?
how to load the data to fact table?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is data modeling and data mining?
what are the session parameters? How do u set them?