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
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
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 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 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 Table Documentation Practices Applying a few table effective practices can: Significantly aide others in understanding the purpose and use of tables and column fieldsProvide more migratable meta data to inform and enable the capabilities of other toolsAnd, from a self-preservation point of view, reduce the number of meetings, emails, and phone required … Continue reading Netezza / PureData – Table Documentation Practices
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