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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is Index Caches size?
What are the differences between joiner transformation and source qualifier transformation?
Can we get 1st record through Informatica(without sequence number).
Separate from a database, an information bazaar, and an information stockroom?
What is a standalone command task?
How do you use reject loader.
What is decode in static cache?
Explain pushdown optimization $pushdownconfig parameter - informatica
How does a sorter cache works?
What is incremental aggregation?
What does role playing dimension mean?
have u done any performance tuning? how u ll do?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?