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...

replace multiple spaces with single space.

Answer Posted / pushpendra

replacechr function can use.

replacechr(0,Column_Name,' ','')

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

2339


What is the function of look up transformation?

1123


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248


What is an Integration service in Informatica?

1134


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1674


What does “tail –f” command do and what is its use as an Informatica admin.

1107


difference between repository database and repository service?

1150


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282


What is blocking transformation?

1144


What are the settings that you use to configure the joiner transformation?

1055


What are the steps involved in the migration from older version to newer version of Informatica Server?

2109


What are the limitations of joiner transformation?

1114


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

1089


What is exclusive and normal mode for repository services?

1144