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
- 14366 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumaravelu
substr('TEST@COMPANY.COM',instr('TEST@COMPANY.COM','@')+1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How many steps etl contains?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what is dynamic insert?
what is the difference steps for data modeling?
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?
Explain what is etl process? How many steps etl contains explain with example?
What is etl process? How many steps etl contains?
What is the difference between project backlog and product backlog?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What are the etl testing operations includes?
Explain what are the various etl tools in the market?
what is different between sequential batch and concurrent batch and which is recommended and why?
Explain about enterprise scalability and roi of data integration suite?
