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 / hariprasad_pulluru
Hi,
You can also parse the string using replace chr to
elminate '|' and find the length of the column
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How would you join a node to the already existing domain?
What is the status code in stored procedure transformation?
What is meant by lookup transformation?
How can we improve session performance in aggregator transformation?
Please let me know how to make encryption and decryption with example?
what is unit testing?tell me proceedure
How to elaborate tracing level?
What is a joiner transformation and why it is an active one?
can u any challenge your project?
What is workflow? What are the components of workflow manager?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to do unit testing in informatica?
Different sorts of metadata that stores in the storage facility?
What are the different clients of powercenter?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?