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?

Data Modeling – Dimension Table Effective Practices

Database Table I've had these notes laying around for a while, so, I thought I consolidate them here.   So, here are few guidelines to ensure the quality of your dimension table structures. Dimension Table Effective Practices The table naming convention should identify it as a dimension table. For example: Suffix Pattern: <<TableName>>_Dim <<TableName>>_D Prefix … Continue reading Data Modeling – Dimension Table Effective Practices

Infosphere DataStage – Designer Client Repository Structure

Default Repository Structure When a project is created, there is a default repository structure created for use in the DataStage designer client. Default DataStage Repository Structure However, some additional organization will be required for most DataStage projects.  Usually, this organization occurs in in these areas: Addition of structure within the “Jobs” folderAddition of a “Parameter … Continue reading Infosphere DataStage – Designer Client Repository Structure