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



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

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

More Informatica Interview Questions

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,


How to elaborate powercenter integration service?

0 Answers  


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  


Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  


how to connect two or more table with single source qualifier?

4 Answers   IBM,






What are two types of processes that informatica runs the session?

2 Answers  


What all are steps in up gradation of Informatica server?

0 Answers  


When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,


Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  


Categories