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
- 8706 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 persistent lookup cache?
How an expression transformation differs from aggregator transformation?
How do you promote a non-reusable transformation to reusable transformation?
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 mapplet in informatica?
How do you take back up of repository?
permutations of mapplet
Difference between Target-based loading and constraint-based loading?
What are the types of schemas we have in data warehouse.
How to update source definition?
How will the document be delivered to me?
How to improve the performance of a session using sorter transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What does reusable transformation mean?
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
