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
- 9528 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
Explain why we use partitioning the session in informatica?
have u done any performance tuning? how u ll do?
What is a stored procedure transformation?
What is the use of transformation?
Is it possible to revert a global repository to local one and why?
Why is sorter an active transformation?
Can u generate reports in Informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to generate sequence numbers?
What is a rank transform?
Is stop and abort are same in informatica?
What is meant by lookup transformation?
How many types of sessions are there in informatica.please explain them?
Is it possible to use a client with different version than that of its Informatica server?
What is a filter transformation and why it is an active one?
