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
- 8702 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
We can find the position of the "|" using INSTR function and
then we can use the SUBSTR function to extract the strings.
We can use Normalizer t/r to put the strings in one column
and then use LENGTH function to find the length of the string.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
server hot-ws270 is connect to Repository B. What does it mean?
what is index?how it can work in informatica
whats the logic to load the lower level of granularity of data to fact table.
What is a rank transform?
Write the unconnected lookup syntax and how to return more than one column.
Explain the shared cache and re-cache?
How to join three sources using joiner? Explain though mapping flow.
How to use pmcmd utility command?
what is mean by complex business rule ?
What is powercenter on grid?
What is substr in informatica?
In warehouses how many schemas are there?
Why do you use Mapping Parameter and mapping variable?
What is persistent lookup cache?
Did u used latest transformations of 8.6.0? for what?
