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

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  


Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  


When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


What is the difference between a router and a filter transformation?

1 Answers   TCS,


How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,






following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


What is partioning?how many types of partinings are there

2 Answers   HCL,


Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,


What is Target Update Override? What is the Use ?

8 Answers   Patni,


Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


Design a mapping to get year of join for each employee.

4 Answers   Accenture,


What is joiner change?

0 Answers  


Categories