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 deployment group?

774


Explain incremental aggregation in informatica

746


What do you mean incremental aggregation?

716


Can you generate sequence numbers without using the sequence generator transformation?

672


What is the different lookup cache(s)?

712






What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1738


Explain about cumulative Sum or moving sum?

701


What is domain and gateway node?

799


Different qualification between a related rotate toward the sky and isolates look upward?

646


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1787


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2018


what is the size of u r source(like file or table)?

1909


Define joiner transformation?

672


can u give example for factless fact table

5735


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

834