DSXchange

Sales force Object has Boolean data type fields which need to be loaded using Datastage.While trying to import the field definitions of object using Sales force connector, it defaults to Varchar data type fields.

I have manually changes the data type to Bit and tried to load the object, but all the records were rejected because of data type mismatch.

Any help is much appreciated!!

Write them as varchar values. It worked!

Interesting... thanks for posting your resolution.