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
- 9341 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
Does an informatica transformation support only aggregate expressions?
How does a rank transform differ from aggregator transform functions max and min?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What does refresh system mean, and what are its distinctive choice?
Where can we find the throughput option in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Enterprise data warehouse your projects phase by phase explain?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the transformations that are not supported in mapplet?
Why update strategy and union transformations are active? Explain with examples.
Which files are created during the session rums by informatics server?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is mapplet in informatica?
How are indexes created after completing the load process?
