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 |
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Howmany ways yoU can update a relational source defintion and what are they?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
What is the difference between a router and a filter transformation?
How You Pull the records on daily basis into your ETL Server.
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?
What is partioning?how many types of partinings are there
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
What is Target Update Override? What is the Use ?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
Design a mapping to get year of join for each employee.
What is joiner change?