Hi, You can also parse the string using replace chr to elminate '

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 ‘|’ .

Question Posted / hariprasad_pulluru

5 Answers
9710 Views
I also Faced
E-Mail Answers

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 are the issues you have faced in your project? How did you overcome those issues?

2407

have u done any performance tuning? how u ll do?

2362

How many input parameters can exist in an unconnected lookup?

1598

Differentiate between reusable transformation and mapplet.

1139

What are the main issues while working with flat files as source and as targets ?

1213

What are the differences between a connected lookup and unconnected lookup?

1120

What is the different lookup cache(s)?

1126

How can we improve session performance in aggregator transformation?

1149

Explain target update override in informatica

1184

What is mapplet in informatica?

1122

Explain the difference between mapping parameter and mapping variable?

1075

Could you explain what is enterprise data warehouse?

1221

what are the Methods For Creating Reusable Transformations?

1249

Differentiate between router and filter transformation?

1061

How to go to the older version for a mapping?

1152