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
- 8638 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 a predefined event?
In which transformation you cannot drag ports into it?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is depict expression change?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the advantage of informatica?
How to update or delete the rows in a target, which do not have key fields?
Why update strategy and union transformations are active? Explain with examples.
What is dimensional table?
What is the fact table?
Design time, run time. If you don't create parameter what will happen
Explain load alternative records / rows into multiple targets - informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
