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...

I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?

Answer Posted / chow

we can do using ltrim and rtrim and concat two words

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enterprise data warehouse your projects phase by phase explain?

1876


without table how to come first record only in oracle?

2219


What is a grid in Informatica?

1032


What is sequence generator transformation in informatica?

1024


What is mapping debugger?

966


What is rank transformation?

950


What is event and what are the tasks related to it?

1082


What is the benefit of session partitioning?

1071


What is the meaning of decode in informatica?

1090


How to generate sequence numbers using expression transformation?

1041


what are factless facts? And in which scenario will you use such kinds of fact tables.

1760


How to update a particular record in target with out running whole workflow?

1551


How do you set a varible in incremental aggregation

1839


How do you update the records with or without using update strategy?

1078


What is the advantage of informatica?

1027