replace multiple spaces with single space.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

580


Explain how many types of dimensions are available in informatica?

593


Make a note of the quantity vaults made in informatica?

553


Explain what are the different types of transformation available in informatica.

571


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

777






Explain incremental aggregation in informatica

652


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

602


What are junk dimensions?

630


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2293


What are the types of schemas we have in data warehouse and what are the difference between them?

519


What is option by which we can run all the sessions in a batch simultaneously?

665


Is stop and abort are same in informatica?

570


What are the components of the workflow manager?

637


What are the new features of Power Center 5.0?

1232


What is aggregate cache in aggregator transformation?

630