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 / 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
SCD2 will work on only dimension tables as well as fact Table?
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 ?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What are materialized views & where do we use them?
What is tracing level and what are the types?
When do we go for the tools in the market?
what is data modeling?
what is the meant by Normalization and de-normalization?
What is a staging area? What is the purpose of a staging area?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Compare etl & elt?
What is the difference between round-robin partitioning and hash partitioning?
how many maximum session supports to multiload in teradata ??
Which transformation we use to convert 'NA' to 'Not Available'
where is the cache (lookup, index) created and how can you see it.