Interested to Buy Any Domain ? << Click Here >> for more details...
Find a way to implement the following logic :
You have column like :
Column 1
AA|BB|CC
DD|EE|FF
WW|AA
I need to get the length of the column without the ‘|’ .
- 5 Answers
- 9738 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
An Easy Way Of Achieving The Output Will Be :-
select length(column_name)-(length(cloumn_name)-length(replace(column_name,'|',''))) from table_name;
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is informatica powercenter repository?
What all join we can perform in LOOKUP transformation?
What is data caches/ index caches?
What are the informatica performance improvement tips
How big was your fact table
How many ways are there to create ports?
How do you set a varible in incremental aggregation
Under which circumstances, informatica server creates reject files?
Can you use flat files in Mapplets.
Explain load alternative records / rows into multiple targets - informatica
Can u generate reports in Informatica?
If informatica has its scheduler why using third party scheduler?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is $$$$?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
