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
- 16970 Views
- I also Faced
- E-Mail Answers
Answer Posted / again kuttu!!
select substr('12132@dfsaf.com',
instr('12132@dfsaf.com', '@')+1,
length('12132@dfsaf.com'))
from dual
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
how do u identify the changed records in operational data?
What are three tier systems in etl?
what is the difference steps for data modeling?
How to fine tune mappings?
dimension object created in oracle can be imported in designer?how?
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.?
How to delete data which is not in source table?
how many steps are there in etl process?
State the differences between shortcut and reusable transformation
Do we need an etl tool?
what are the reports developed in sap bw project and what is the requirement for developing it?
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.
where we cannot use sorter Transformation. if we use then we will not get correct data?
Is hadoop a etl tool?
how do u set partition points in the mapping?
