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


Please Help Members By Posting Answers For Below Questions

How would you copy the content of one repository to another repository?

772


Describe data concatenation?

790


What is transformation?

881


How can we use batches?

795


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1860


What is a code page?

911


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1286


What is informatica powercenter repository?

918


What does reusable transformation mean?

868


What is decode in static cache?

800


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1820


Explain the features of connected and unconnected lookup.

733


How can you differentiate between powercenter and power map?

845


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2009


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2105