Limitation of REPLACESTR. Is there any character limitation to it.

Answer Posted / kumar

replacestr function won't work for characters larger than 65535.

https://etltechsolutions.wordpress.com/2016/05/11/error-message-is-replacestr-data-too-large/

and

https://network.informatica.com/thread/3080

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the features of connected and unconnected lookup.

548


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

602


What are the reusable transformations?

701


Scheduling properties,whats the default (sequential)

1470


What is a sorter transformation?

664






Why union transformation is an active transformation?

659


without table how to come first record only in oracle?

1860


On which transformations you created partitions in your project?

763


Explain the mapping variable usage example in informatica

635


To import the flat file definition into the designer where should the flat file be placed?

679


What is parallel processing in informatica?

1032


What are the differences between a connected lookup and unconnected lookup?

654


What is domain and gateway node?

700


What does refresh system mean, and what are its distinctive choice?

567


What are the modules in Power Center

1240