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
How would you copy the content of one repository to another repository?
Describe data concatenation?
What is transformation?
How can we use batches?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a code page?
pmscmd startworkflow -sv
What is informatica powercenter repository?
What does reusable transformation mean?
What is decode in static cache?
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
Explain the features of connected and unconnected lookup.
How can you differentiate between powercenter and power map?
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?
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.