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
- 9332 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 are the advantages of using informatica as an etl tool over teradata?
What is the cumulative sum and moving sum?
What are the components of workflow manager?
What is the difference between STOP and ABORT options in Workflow Monitor?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the scenario which compels informatica server to reject files?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
explain abt ur project architecture?
How do you use reject loader.
Explain sessions?
Enlist few areas or real-time situations where informatica is required.
What is the benefit of partitioning a session?
Plz can any one say me how to get the informatica certification materials and dumps
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What does “tail –f” command do and what is its use as an Informatica admin.
