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

Define filter transformation?

1105


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2085


Plz can any one say me how to get the informatica certification materials and dumps

2058


Separate from a database, an information bazaar, and an information stockroom?

1094


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1778


In how many ways we can create ports?

1132


What is a dimensional model?

993


What is the cumulative sum and moving sum?

1196


difference between repository database and repository service?

1162


What is update strategy transform?

1120


What are the different ways to implement parallel processing in informatica?

1433


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1592


Explain pmcmd command usage in informatica

1141


What is Session and Batches?

1115


What the difference is between a database, a data warehouse and a data mart?

1161