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

Difference between Target-based loading and constraint-based loading?

777


Can you use flat files in Mapplets.

2439


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1765


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1535


Briefly define reusable transformation?

860


What are the types of schemas we have in data warehouse.

743


How might you approve all mappings in the archive all the while?

827


Is it possible to use a client with different version than that of its Informatica server?

888


What is informatica? Why do we need it?

879


What do you understand by SOA of Informatica?

770


have u done any performance tuning? how u ll do?

2090


Define filter transformation?

883


What is meant by incremental aggregation?

783


How to differentiate between the active and passive transformations?

866


What are the modules in Power Center

1449