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 |
Where are the source flat files kept before running the session?
What is a repository? And how to add it in an informatica client?
How to generate sequence numbers without using the sequence generator transformation?
Explain reference cursor?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How might you approve all mappings in the archive all the while?
what are the limitations of pushdown optimization technique ? Advance thanks
What is the difference between writing a joiner query in ANSI style and THETA style?
I want skip first 5 rows to load in to target? what will be the logic at session level ??
Differentiate between a repository server and a powerhouse?
What is informatica etl tool?
how to get flatfile containg 10 records half records one target another half another target