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

How can repository reports be accessed without sql or other transformations?

721


Explain pmcmd command usage in informatica

699


Define sessions in informatica etl?

613


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4774


How many types of sessions are there in informatica.please explain them?

675






What are the advantages of using informatica as an etl tool over teradata?

563


How do you use reject loader.

2067


How does the aggregator transformation handle null values?

695


How do you change a non-reusable transformation to reusable transformation?

592


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1177


what is the Default Source Option For Update Strategy Transformation?

753


What are mapplets? How is it different from a Reusable Transformation?

622


What do you mean by enterprise data warehousing?

638


What is the status code in stored procedure transformation?

683


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

611