replace multiple spaces with single space.

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

Which development components of informatica have the highest usage?

0 Answers  


What is the Difference between sorter and aggregator?

2 Answers  


What are the basic needs to join two sources in a source qualifier?

3 Answers  


What is a transaction control transformation?

0 Answers   Informatica,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,






how to run the batch using pmcmd command

2 Answers   Wipro,


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


what are challenges that you faced in testing? give solution to it?

1 Answers  


What are the basic needs to join two sources in a source qualifier?

4 Answers  


What is active and passive transformation?

10 Answers  


In how many ways we can create ports?

0 Answers  


What are the restrictions of union transformation?

0 Answers  


Categories