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 ‘|’ .
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 the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Which version configuration tool used in ur project?
Under what condition selecting sorted input in aggregator may fail the session?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Mention some types of transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
difference between informatica 8.1.1 and 8.6
How many ways a relational source definition can be updated and what are they?
What are the reusable transformations?
How can one identify whether mapping is correct or not without connecting session?
How might one distinguish in the case of mapping is right or not without associating session?
What are the mapping parameters and mapping variables?
What is primary and backup node?
Explain the scenario which compels informatica server to reject files?
What is workflow monitor?