This content has been marked as final. Show 3 replies
I want to mention that how stupidly I have solved this issue.
I was creating the page in UTF-8 which was correct but Informatica was taking it as Windows Latin. ( I am not sure why may be drop down value of of UTF-8 is saving in informatica db wrongly)
From the error it is shown that I am creating the page in Windows Latin whereas Informatica support UTF-8.
So what I did? I did below steps
executed below on Informatica db
SELECT * FROM OPB_REPOSIT;
Come to know that CODE_PAGE_ID (2252) tends to Windows Latin. Here I update the COD_PAGE_ID to 106 (UTF-8)
Refresh the informatica page and error flew away. Integration service also created smoothly.
Agree or not, I have solved the problem in this way.
Can someone tell me the side affects of this operation?