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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1106


Does an informatica transformation support only aggregate expressions?

970


What are the types of schemas we have in data warehouse and what are the difference between them?

887


Where are the source flat files kept before running the session?

1010


explain abt ur project architecture?

2122


How to differentiate between the active and passive transformations?

1075


Explain Dataware house architecture .how data flow from intial to end?

2526


Explain scd type 3 through mapping.

916


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1442


wat are deployement groups in informatica, how it will be used for developers

1667


What are the issues you have faced in your project? How did you overcome those issues?

2288


What is complex mapping?

1068


Why update strategy and union transformations are active? Explain with examples.

1173


EXL informatica Questions

1310


permutations of mapplet

2454