SFDC – Using a timestamp literal in a where clause

Working with timestamp literals in the Infosphere SFDC Connector soql is much like working date literals.  So, here a quick example which may save you some time. SOQL Timestamp String Literals Where Clause Rules Basically, the timestamp pattern is straight forward and like the process for dates, but there are some differences. The basic rules … Continue reading SFDC – Using a timestamp literal in a where clause

SFDC Salesforce Connector – Column Returns Null values, when SOQL Returns Data in Workbench

Recently, encountered a scenario, which is a little out of the norm while using the SFDC Connector.  Once the issue is understood, it is easily remedied. The problem / Error SOQL run in Salesforce workbench and column returns data The DataStage job/ETL runs without errors or warnings The target column output only returns null values … Continue reading SFDC Salesforce Connector – Column Returns Null values, when SOQL Returns Data in Workbench

SFDC – Using a date literal in a where clause

I found working with date literal, when working with the Infosphere SFDC Connector soql, to be counterintuitive for me.  At least as I, normally, as I use SQL.  I spent a little time running trials in Workbench, before I finally locked on to the ‘where clause’ criteria data pattern.  So, here a quick example. SOQL DATE … Continue reading SFDC – Using a date literal in a where clause