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
- 14367 Views
- I also Faced
- E-Mail Answers
Answer Posted / kuttu
select trim(replace('2-3-4','-',NULL)) from dual
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the use lookup tables and Aggregate tables?
What is abap? What are idocs?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
explain the methodology of Data Warehousing?(Polaries)
What is grain of fact?
what is pmrep command?
What are the names of the layers in etl?
where is the cache (lookup, index) created and how can you see it.
What are the different etl testing categories as per their function?
Explain about hash partitioning?
What is data cleaning?
What do you understand by active and passive transformations?
what is data modeling?
what is pmrep command?
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.
