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
- 7946 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 intricate mapping?
Define update strategy?
What is persistent lookup cache?
What is sq transformation?
How many number of sessions can one group in batches?
What are the data movement modes in informatica?
Explain the types of transformations?
Can we create a Integration service without a Repository service and vice versa?
How can repository reports be accessed without sql or other transformations?
What is the commit type if you have a transaction control transformation in the mapping?
How do you load alternate records into different tables through mapping flow?
How do you convert single row from source into three rows into target?
What are the differences between oltp and olap?
Explain the shared cache and re-cache?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
