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

Can we create a Integration service without a Repository service and vice versa?

1253


Explain direct and indirect flat file loading (source file type) - informatica

1354


What are the static cache and dynamic cache in informatica?

1241


Explain the different lookup methods used in informatica?

1090


What are the data movement modes in informatica?

1206


What is the use of transformation?

1049


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2410


Explain in detail scd type 2 through mapping.

1083


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2397


How to start a workflow using pmcmd command?

1296


What are the types of caches in lookup?

1094


Is stop and abort are same in informatica?

1039


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1296


What is the difference between source qualifier transformations source filter to filter transformation?

1085


While migrating the data from one environment to another environment how would you manage the connections?

1125