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

Highlighted
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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now