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 / hariprasad_pulluru

Hi,

You can also parse the string using replace chr to
elminate '|' and find the length of the column

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by lookup transformation? Explain the types of lookup transformation?

754


EXL informatica Questions

1158


What is Session and Batches?

888


my source is junk data how will u remove that junk data by using unix please any one replay me

3479


Suppose we do not group by on any ports of the aggregator what will be the output?

834


what is the hint? how to use it to reduce the query processing in program?

7165


what is the complex transformation you used in informatica

2402


what is diff b/t sorter t/r and agg have the option sorter property...

1966


How to create the source and target database connections in server manager?

848


What is the advantage of informatica?

843


What are active and passive transformations?

844


Explain your project of banking domian.

1416


Why do we need informatica?

756


what are factless facts? And in which scenario will you use such kinds of fact tables.

1540


4 yrs etl devloper roles and responsibilities?any body give solutions

1867