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
have u done any performance tuning? how u ll do?
What are the differences between oltp and olap?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
In informatics server which files are created during the session rums?
What does command task mean?
Is it possible to define a single node as a Gateway node as well as worker node?
Which are the different editions of informatica powercenter that are available?
What is meant by query override?
What is status code in informatica?
What is the surrogate key?
what is size of u r database?
What is the use of an aggregator cache file?
whats the logic to load the lower level of granularity of data to fact table.
In how many ways we can create ports?