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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

replace multiple spaces with single space.

Question Posted / kartik

Answers were Sorted based on User's Feedback



replace multiple spaces with single space...

Answer / pushpendra

replacechr function can use.

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

Is This Answer Correct ?    0 Yes 0 No

replace multiple spaces with single space...

Answer / xx

Its always better to use reg_replace check the below link

https://etltechsolutions.wordpress.com/category/informatica/

Is This Answer Correct ?    1 Yes 1 No

replace multiple spaces with single space...

Answer / kartik

Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

What is router transformation

4 Answers   CSC,

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

need for registering a repository server

1 Answers  

Explain the types of lookup transformation?

0 Answers  

Explain transaction control transformation in informatica

0 Answers   Informatica,

what is metadata?

8 Answers   Satyam,

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

How to display First letter of Names in Caps?

7 Answers  

For more Informatica Interview Questions Click Here
Categories