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 is the function of union transformation?
How is union transformation utilized?
Explain transaction control transformation in informatica
What does role playing dimension mean?
What is parallel processing in informatica?
Can we create a Integration service without a Repository service and vice versa?
Define pmcmd command?
Why union transformation is an active transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to elaborate tracing level?
What is substr in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What do you mean by enterprise data warehousing?