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
- 9713 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
In which transformation you cannot drag ports into it?
How can we use mapping variables in informatica? Where do we use them?
How to elaborate tracing level?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
how tokens will generate?
What is a filter transformation?
While migrating the data from one environment to another environment how would you manage the connections?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the use of code page?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are active and passive transformations?
How can you differentiate between powercenter and power map?
What do you mean by enterprise data warehousing?
What are the new features of Power Center 5.0?
How can a transformation be made reusable?
