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
- 9712 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
In development project what is the process to follow for an etl developer from day1
What will be the approach?
What are active transformations.
What do you understand by a term domain?
What is blocking transformation?
How are indexes created after completing the load process?
what is the size of your data warehousing?
Tell me about Propagate functions in informatica
What are the types of data warehouses?
What is workflow? What are the components of the workflow manager?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is xml source qualifier transformation in informatica?
How to create Target definition for flat files?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to convert multiple rows to single row (multiple columns) in informatica
