Tuesday, September 17, 2013
How to move binary (raw) data with Informatica Power Center
Although Power Center shows this as possible, unfortunately you can not move binary or raw columns from source to target normally. You can try relational writer or external loader result is same. Binary/Raw column will be null.
It is impossible to convert this column as well.
Easiest way to do this is changing column definitions to varchar or nvarchar2 in Power Center. You do not have to change it on Database level at all. Data will start to move around as magic :)
This comment has been removed by the author.
ReplyDeletethis is wrong. you can't do this.
ReplyDelete