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
What are session parameters ? How do you set them?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is enterprise data warehousing?
What is event and what are the tasks related to it?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a difference between complete, stop and abort?
Enlist the tasks for which source qualifier transformation is used.
What is joiner transformation?
How can we use mapping variables in informatica?
How do you take back up of repository?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Briefly define reusable transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
How many transformations can be used in mapplets.
How would you copy the content of one repository to another repository?