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

What does CRM Mean?

  What is CRM? CRM (customer relationship management) is a type of ERP application, which are used to facilitate sales, marketing, and business development interactions throughout the customer life cycle. What does a CRM Application do? A CRM application capabilities, broadly, encompass: Marketing Integration Lead management, email marketing, and campaign management Sales Force Automation Contact management, … Continue reading What does CRM Mean?

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