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

What is Information Management?

Information Management Definition Information Management (IM) tends to vary a based on your business perspective, but is all the systems, processes, practice (business and technical) within organizations for the creation, use, and disposal of business information to support business operations. Information Management (IM) Activities Information Management activities may include, but are not be limited to: … Continue reading What is Information Management?

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 is an ERP?

What does ERP mean? ERP Means "Enterprise Resource Planning" What is an ERP? An ERP is business software application or series of applications, which facilitate the daily operations of business. An ERP an be commercial-off-the-shelf (COTS) applications (which may or may not be customized) or custom built (home grown) by the business and/or assemblages of … Continue reading What is an ERP?

Salesforce – Useful Links

  Here are few SFDC link, which I have found to be useful. Salesforce Developers Home, Developer Documentation, Force.com SOQL and SOSL Reference https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm IBM Knowledge Center InfoSphere Information Server, InfoSphere Information Server 11.5.0, Connecting to data sources, Enterprise applications, IBM InfoSphere Information Server Pack for Salesforce.com https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.entpak.salesf.doc/topics/SalesforcePackOverview.html Salesforce Developers Home, Technical Library, Workbench https://developer.salesforce.com/page/WorkbenchContinue reading Salesforce – Useful Links

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