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 |
sorce is a flatfile only 1st and last row should insert to target how will u do?
what is data driven?
What is a sorter transformation?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
Why union transformation is an active transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
What is an Integration service in Informatica?
How to load a Dimension ? and how to load a fact table?
How union transformation is used?