OLTP vs Data Warehousing

OLTP Versus Data Warehousing I’ve tried to explain the difference between OLTP systems and a Data Warehouse to my managers many times, as I’ve worked at a hospital as a Data Warehouse Manager/data analyst for many years. Why was the list that came from the operational applications different than the one that came from the … Continue reading OLTP vs Data Warehousing

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

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?