[resolved] How to move Salesforce boolean type fields into Teradata

[Anonymous]

I am trying to create a job that pulls data from Salesforce and inserts into a new table in Teradata. It always fails whenever I try to pull a field with a boolean type. There is no corresponding equivalent in Teradata. If I try to edit the Teradata schema to push it in as an integer or a char field it still fails. What do I need to do to convert boolean data type to a field type that can be loaded into Teradata?

[Anonymous · Accepted solution]

Hi
You can simple convert boolean type to Integer/int type on tMap, for example:
row1.columnName==true?1:0
Shong