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 ‘|’ .

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


Please Help Members By Posting Answers For Below Questions

What is persistent lookup cache?

810


How an expression transformation differs from aggregator transformation?

843


How do you promote a non-reusable transformation to reusable transformation?

927


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?

1944


What is mapplet in informatica?

797


How do you take back up of repository?

935


permutations of mapplet

2279


Difference between Target-based loading and constraint-based loading?

777


What are the types of schemas we have in data warehouse.

743


How to update source definition?

878


How will the document be delivered to me?

837


How to improve the performance of a session using sorter transformation?

940


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3636


What does reusable transformation mean?

891


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2109