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
- 9723 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 manage the Parameter files while migrating your data from one environment to another environment?
How to start a workflow using pmcmd command?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a surrogate key?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the meaning of up gradation of repository?
What are the modules in Power Center
Differentiate between router and filter transformation?
What is the use of code page?
Describe the impact of several join conditions and join order in a joiner transformation?
can u any challenge your project?
Which files are created during the session rums by informatics server?
Scheduling properties,whats the default (sequential)
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Briefly explain the aggregator transformation?
