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
- 16980 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
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what are the facilities provided by data warehouse to analytical users?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
How many steps etl contains explain with example?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what are the data modeling tools you have used?(polaris)
how do u identify the changed records in operational data?
what is the main role of FI on business
what is pmrep command?
how would u estimate the size of Aggregator transform data and index cache?
what are the reporting tools and difference between them?
what is the difference between cubes and package in cognos
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
What is a staging area? What is the purpose of a staging area?
