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
- 9527 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 repository manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
difference between repository database and repository service?
How big was your fact table
Explain the tuning lookup transformation - informatica
What are batches?
What are the main issues while working with flat files as source and as targets ?
What all join we can perform in LOOKUP transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Which means the first record should come as last record and last record should come as first record and load into the target file?
Define sessions in informatica etl?
What is flashback table ? Advance thanks
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the different options available for update strategy?
What is a sorter transformation?
