Netezza / PureData – How to add multiple columns to a Netezza table in one SQL

  I had this example floating around in a notepad for a while, but I find myself coming back it occasionally.  So, I thought I would add it to this blog for future reference. The Table Alter Process This is an outline of the Alter table process I follow, for reference, in case it is … Continue reading Netezza / PureData – How to add multiple columns to a Netezza table in one SQL

Netezza / PureData – How to add a Foreign Key

DDL (Data Definition Language) Adding a forging key to tables in Netezza / PureData is a best practice; especially, when working with dimensionally modeled data warehouse structures and with modern governance, integration (including virtualization), presentation semantics (including reporting, business intelligence and analytics). Foreign Key (FK) Guidelines A primary key must be defined on the table … Continue reading Netezza / PureData – How to add a Foreign Key

Database – What is a foreign key?

Acronyms, Abbreviations, Terms, And Definitions Definition of a Foreign Key A foreign Key (FK) is a constraint that references the unique primary key (PK) of another table. Facts About Foreign Keys Foreign Keys act as a cross-reference between tables linking the foreign key (Child record) to the Primary key (parent record) of another table, which … Continue reading Database – What is a foreign key?

Database – What is a Composite Primary Key?

Database Table What is a Composite Primary Key? A Composite Primary key is Primary key What a primary key, which is defined by having multiple fields (columns) in it.  Like a Primary Key what a composite Primary Key is depends on the database.  Essentially a Composite Primary Key: Is a combination of Fields (columns) which … Continue reading Database – What is a Composite Primary Key?

Database – What is a Primary Key?

Database Table What is a primary Key? What a primary key is depends, somewhat, on the database.  However, in its simplest form a primary key: Is a field (Column) or combination of Fields (columns) which uniquely identifies every row.Is an index in database systems which use indexes for optimizationIs a type of table constraintIs applied … Continue reading Database – What is a Primary Key?

Netezza/ PureData – how to add a primary key

Netezza / PureData Create Primary Key (PK) While primary keys (PK) are not enforced within Netezza, they still provide significant value and should be added.  Among the values that adding primary key provides are: Inform tools, which have meta Data import capabilities; for example, Aginity, ETL tools, data modeling tools, Infosphere Data Architect, DataStage and … Continue reading Netezza/ PureData – how to add a primary key