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
- 9535 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 to do the error handling of if ur source is flatfiles?
Define update strategy?
What does “tail –f” command do and what is its use as an Informatica admin.
What is mapplet in informatica?
waht type of interface is used for testing the data in informatica
r u done any partitions in ur project?
What are roles and groups and benefits of using them?
If informatica has its scheduler why using third party scheduler?
Define joiner transformation?
What are the mapping parameters and mapping variables?
Write the unconnected lookup syntax and how to return more than one column.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What do you understand by SOA of Informatica?
What are the types of lookup transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
