Syntax to create surrogate keys in a table

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Syntax to create surrogate keys in a table

Rate Topic

Display Mode

Topic Options

Author

Message

rlaskar

Posted 3/22/2006 1:26:33 PM

Junior Member

Group: Forum Members
Last Login: 6/18/2007 5:02:00 PM
Posts: 18, Visits: 1

I was trying to create a table with surrogate keys defined.

Post #3809

Vinay Bagare

Posted 4/21/2006 10:56:54 AM

Supreme Being

Group: Forum Members
Last Login: 10/7/2008 6:20:30 PM
Posts: 136, Visits: 11

I don't know if you have got any replies on this.
We had implemented separate KEY and MAP tables in past.

These key tables will have a surrogate key and also their natural key counterpart. In fact the first loading job in the ETL was to load these Key tables. Generate new keys if they don't exist.

I don't think there is any direct way to generate Surrogte keys.

Vinay

Post #4024

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 12:55am