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
- 9547 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
What is a predefined event?
Explain about Informatica server process that how it works relates to mapping variables?
What do you mean by filter transformation?
How many input parameters can exist in an unconnected lookup?
How to use pmcmd utility command?
Which files are created during the session rums by informatics server?
How do you load alternate records into different tables through mapping flow?
Can u generate reports in Informatica?
How to create a non-reusable instance of reusable transformations?
Explain sessions. Explain how batches are used to combine executions?
Differentiate between sessions and batches?
What are the prerequisite tasks to achieve the session partition?
What are mapplets?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Differentiate between a repository server and a powerhouse?
