Skip to main content

developerWorks >  Information Management  >  Forums  >  IBM InfoSphere Data Architect  >  developerWorks

Repeating Standard Set of Attributes and FKs onto many Entities    Point your RSS reader here for a feed of the latest messages in this thread


Tags for this thread: 

     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
This question is not answered.

Permlink Replies: 3 - Pages: 1 - Last Post: Oct 1, 2009 5:52 AM Last Post By: DawnPickett
rayweekes

Posts: 1
Registered: Jul 21, 2009 09:52:49 AM
Repeating Standard Set of Attributes and FKs onto many Entities
Posted: Jul 21, 2009 10:10:32 AM
 
Click to report abuse...   Click to reply to this thread Reply
I would like to have a standard set of attributes and foreign key relations repeated on many tables.
For example; Created By User Name, Created by Date and Time, etc.

Is there a simple way to set up such a group just the once and then include them on various tables without having to copy them eveytime?
Ideally if I want to add/change something about the set of common attributes then I need only change it once and it would automatically percolate through to wherever it is used.
erik.gollot

Posts: 24
Registered: Mar 26, 2009 04:31:50 AM
Re: Repeating Standard Set of Attributes and FKs onto many Entities
Posted: Aug 08, 2009 03:10:40 AM   in response to: rayweekes in response to: rayweekes's post
 
Click to report abuse...   Click to reply to this thread Reply
You can use a pluglet to do that i.e. write Java code to initialize your tables with a set of standard attributes.
vmcburney

Posts: 58
Registered: Aug 09, 2005 02:32:34 AM
Re: Repeating Standard Set of Attributes and FKs onto many Entities
Posted: Sep 30, 2009 12:45:13 AM   in response to: rayweekes in response to: rayweekes's post
 
Click to report abuse...   Click to reply to this thread Reply
I had the same problem. I am modeling a data warehouse so I have the same three metadata fields on every table but I could not find any way in Data Architect to set it up or maintain it over time. The search and replace, domain entity and modification and update functions were all disappointing in regards to these global columns.

Vincent McBurney
DawnPickett

Posts: 8
Registered: Jul 21, 2006 10:20:11 AM
Re: Repeating Standard Set of Attributes and FKs onto many Entities
Posted: Oct 01, 2009 05:52:39 AM   in response to: erik.gollot in response to: erik.gollot's post
 
Click to report abuse...   Click to reply to this thread Reply
Erik, that's all very well, but what if one doesn't have Java Skills, let alone knowledge in how the eclipse environment works? Do you have any example pluglets or links to how this might be done?
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums