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
What is meant by lookup transformation? Explain the types of lookup transformation?
EXL informatica Questions
What is Session and Batches?
my source is junk data how will u remove that junk data by using unix please any one replay me
Suppose we do not group by on any ports of the aggregator what will be the output?
what is the hint? how to use it to reduce the query processing in program?
what is the complex transformation you used in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
How to create the source and target database connections in server manager?
What is the advantage of informatica?
What are active and passive transformations?
Explain your project of banking domian.
Why do we need informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
4 yrs etl devloper roles and responsibilities?any body give solutions