How to know if your Oracle Client install is 32 Bit or 64 Bit

  How to know if your Oracle Client install is 32 Bit or 64 Bit Sometimes you just need to know if your Oracle Client install is 32 bit or 64 bit. But how do you figure that out? Here are two methods you can try. The first method Go to the %ORACLE_HOME%\inventory\ContentsXML folder and … Continue reading How to know if your Oracle Client install is 32 Bit or 64 Bit

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

Netezza / PureData – Table Describe SQL

If you want to describe a PureData / Netezza table in SQL, it can be done, but Netezza doesn’t have a describe command.  Here is a quick SQL, which will give the basic structure of a table or a view.  Honestly, if you have Aginity Generating the DDL is fast and more informative, at least … Continue reading Netezza / PureData – Table Describe SQL

Netezza / PureData – Substring Function Example

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string. Substring Functions Basic Syntax SUBSTRING Function Syntax SUBSTRING(<<CharacterField>>,<< StartingPosition integer>>, <<for Number of characters Integer--optional>>)   SUBSTR Function Syntax SUBSTR((<>,<< StartingPosition integer>>, <>)   Example Substring SQL Substring SQL Used In Example SELECT  LOCATIONTEXT … Continue reading Netezza / PureData – Substring Function Example

Netezza / PureData – Substring Function On Specific Delimiter

The function Substring (SUBSTR) in Netezza PureData provides the capability parse character type fields based on position within a character string.  However, it is possible, with a little creativity, to substring based on the position of a character in the string. This approach give more flexibility to the substring function and makes the substring more … Continue reading Netezza / PureData – Substring Function On Specific Delimiter

Netezza / PureData – Position Function

  The position function in Netezza is a simple enough function, it just returns the number of a specified character within a string (char, varchar, nvarchar, etc.) or zero if the character not found. The real power of this command is when you imbed it with character function, which require a numeric response, but the … Continue reading Netezza / PureData – Position Function

Data Modeling – Column Data Classification

Data Modeling Column Data Classification When analyzing individual column data, at its most foundational level, column data can be classified by their fundamental use/characteristics.  Granted, when you start rolling up the structure into multiple columns, table structure and table relationship, then other classifications/behaviors, such as keys (primary and foreign), indexes, and distribution come into play.  … Continue reading Data Modeling – Column Data Classification