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
What is source qualifier transformation in informatica?
Why is sorter an active transformation?
What is a repository manager?
In informatica workflow manager, how many repositories can be created?
What will be the approach?
What are the new features of informatica 9.x at the developer level?
How many ways are there to create ports?
What is a mapplet/worklet in informatica?
Explain lookup transformation is active in informatica
What are the types of lookup transformation?
What is DR strategy for Informatica project?
Could you explain what is enterprise data warehouse?
wat are deployement groups in informatica, how it will be used for developers
Where can we find the throughput option in informatica?
How to extract the informatica rejected data?