Interested to Buy Any Domain ? << Click Here >> for more details...
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 ‘|’ .
- 5 Answers
- 9293 Views
- I also Faced
- E-Mail Answers
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
How do you remove duplicate records in informatica? And how many ways are there to do it?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is rank transformation in informatica
How to Create a folder using pmrep command?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is blocking transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What you know about transaction control transformation?
Difference between Target-based loading and constraint-based loading?
Can u generate reports in Informatica?
What is an Integration service in Informatica?
What is data transformation manager process?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Slowly changing dimensions, types and where will you use them
difference between repository database and repository service?
