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 / 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 to fine tune mappings?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the different etl testing categories as per their function?
What is etl tool in hadoop?
What are the names of the layers in etl?
Explain etl mapping sheets?
Explain what are the various etl tools in the market?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What are the types of Data Warehouse applications?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is a worklet?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what is data modeling?