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
- 9559 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
How to load the data from people soft hrm to people soft erm using informatica?
How to join three sources using joiner?
Which are the different editions of informatica powercenter that are available?
What is a node in Informatica?
What are the types of caches in lookup? Explain them.
explain one complex mapping with logic? sales project?
Which is the t/r that builts only single cache memory?
What is an expression transformation in informatica?
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 informatica etl tool?
What is repository manager?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
When do you use sql override in a lookup transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
