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 / abhinav prakash

Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to partition the Session?

862


How do you load unique records into one target table and duplicate records into a different target table?

969


What is sorter transformation?

801


What is enterprise data warehousing?

817


Explain the different dimensions.

754


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1885


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

933


How can you validate all mappings in the repository simultaneously?

1064


Quickly characterize reusable change?

921


What is InformaticaPowerCenter?

913


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2016


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

7162


What are the basic requirements to join two sources in a source qualifier transformation using default join?

832


What are batches?

822


How to update or delete the rows in a target, which do not have key fields?

921