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
- 16517 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish
select replace ('323-237-2323','-') from dual
select substr('test@company.com',6,11) from dual
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is apache nifi an etl tool?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Can there be sub steps of etl steps?
What is a materialized view log?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
what do u do when DB time takes more?in sap bi
where are the log files generally stored.Can you change the path of the file.what can the path be?
Compare etl & elt?
Two default user groups created in the repository are____and_____.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What is etl tool in hadoop?
what are Lookup caches options? Including persistent caches.
what is an ETL or ETT? And what are the different types?
What is the difference between Data Warehousing and Data Mining?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
