replace multiple spaces with single space.
Answers were Sorted based on User's Feedback
Answer / pushpendra
replacechr function can use.
replacechr(0,Column_Name,' ','')
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / kartik
Hops I ound Trip Time robe1
to
Hops I ound Trip Time robe1
Is This Answer Correct ? | 0 Yes | 1 No |
Which development components of informatica have the highest usage?
What is the Difference between sorter and aggregator?
What are the basic needs to join two sources in a source qualifier?
What is a transaction control transformation?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
how to run the batch using pmcmd command
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
what are challenges that you faced in testing? give solution to it?
What are the basic needs to join two sources in a source qualifier?
What is active and passive transformation?
In how many ways we can create ports?
What are the restrictions of union transformation?