Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ‘|’ .

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

What is source qualifier transformation in informatica?

1011


Why is sorter an active transformation?

1129


What is a repository manager?

1094


In informatica workflow manager, how many repositories can be created?

1362


What will be the approach?

979


What are the new features of informatica 9.x at the developer level?

1043


How many ways are there to create ports?

1332


What is a mapplet/worklet in informatica?

1188


Explain lookup transformation is active in informatica

1104


What are the types of lookup transformation?

1081


What is DR strategy for Informatica project?

1185


Could you explain what is enterprise data warehouse?

1148


wat are deployement groups in informatica, how it will be used for developers

1719


Where can we find the throughput option in informatica?

1063


How to extract the informatica rejected data?

1220