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
- 14371 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkateswara rao
--Written in sqlserver
declare @num varchar(100) ='323-237-2323'
, @str varchar(100) ='TEST@COMPANY.COM'
, @ind int
set @ind= CHARINDEX('@',@str)
select SUBSTRING(@str,@ind+1,LEN(@str))
print @ind
select REPLACE(@num,'-','')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain different types of partitioning?
What is tracing level? How many types of transformations supported by sorted input?
What are dimensions?
what are the data modeling tools you have used?(polaris)
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
How to fine tune mappings?
what are the facilities provided by data warehouse to analytical users?
what are the session parameters? How do u set them?
how does the server recongnise the source and target databases.Elaborate on this
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.?
What do you understand by active and passive transformations?
What are the etl testing operations includes?
how would u estimate the size of Aggregator transform data and index cache?
how do u handle performance issues in Informatica . where can u monitor the performance ?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
