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

One Star

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

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?

Accepted Solutions
Community Manager

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

Hi
You can simple convert boolean type to Integer/int type on tMap, for example:
row1.columnName==true?1:0
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

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

Hi
You can simple convert boolean type to Integer/int type on tMap, for example:
row1.columnName==true?1:0
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business