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

What do you mean by filter transformation?

953


tell me the rules and responsblites in our project(my project is development)

1933


draw informatica architecture 8.6 ?

3873


is it possible to index the data in cache of lkp transformation ?

2029


What are the different types of repositories created using informatica?

1140


What is mapplet in informatica?

1057


What is an active transformation?

1110


What are the main features of Oracle 8i with context to datawarehouse?

2112


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2122


What is the cumulative sum and moving sum?

1186


what is the difference between informatica6.1 and infomatica7.1

2278


Clarify the utilization of aggregator cache record?

1002


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1082


Do you find any difficulty while working with flat files as source and target?

1098