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
- 9291 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 different between the data warehouse and data mart?
What is meant by lookup transformation?
Explain the different kinds of facts.
Which development components of informatica have the highest usage?
How to extract the informatica rejected data?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What do you mean by blocking transformation?
difference between repository database and repository service?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what is INFORMATICA TESTING process
Whats there in global repository
Explain direct and indirect flat file loading (source file type) - informatica
What is lookup transformation?
Explain about cumulative Sum or moving sum?
Explain lookup transformation in informatica
