replacechr function can use. replacechr(0,Column

replace multiple spaces with single space.

Question Posted / pushpendra

Answer Posted / pushpendra

replacechr function can use.

replacechr(0,Column_Name,' ','')

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1076

Which is the t/r that builts only single cache memory?

1234

How are indexes created after completing the load process?

1716

Describe data concatenation?

1117

What is meant by lookup transformation?

1176

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10725

How do you use reject loader.

2645

How to do the error handling of if ur source is flatfiles?

2012

What is target designer and target load order?

1166

What are the prerequisite tasks to achieve the session partition?

1293

What are the components of Informatica? And what is the purpose of each?

1108

Explain target update override in informatica

1183

What are the steps involved in the migration from older version to newer version of Informatica Server?

2150

What is the status code in stored procedure transformation?

1228

Explain lookup transformation is active in informatica

1144