little tips and tricks, which i stumbled upon randomly

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 :)

2 comments: