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

write dql command replace to remove the | and save the result in variable port.find the length of that port by using lenth().....

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1865


What is Index Caches size?

867


What are the differences between joiner transformation and source qualifier transformation?

902


Can we get 1st record through Informatica(without sequence number).

1230


Separate from a database, an information bazaar, and an information stockroom?

848


What is a standalone command task?

917


How do you use reject loader.

2344


What is decode in static cache?

822


Explain pushdown optimization $pushdownconfig parameter - informatica

938


How does a sorter cache works?

814


What is incremental aggregation?

841


What does role playing dimension mean?

827


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

2088


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

914


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

859