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 / chanakya123

Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is workflow? What are the components of workflow manager?

1232


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2355


What are the transformations that are not supported in mapplet?

1084


What are the informatica performance improvement tips

1152


scenario where i can use only concurrent execution of workflow.

3262


Explain what is informatica metadata and where is it stored?

1108


What is joiner transformation in informatica?

1100


can u give example for factless fact table

6783


what is size of u r database?

2365


How to go to the older version for a mapping?

1159


What is persistent lookup cache?

1098


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2108


Performance tuning( what you did in performance tuning)

2058


What are the performance considerations when working with aggregator transformation?

1209


How to create a non-reusable instance of reusable transformations?

1170