Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Mapping - Multiple Sources to 1 Table / Column
Topic Summary: Mapping - How do we map multiple sources to 1 table/column
Created On: 16-May-2006 17:42
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 16-May-2006 17:42
User is offline View Users Profile Print this message


Jane Stevens

Posts: 17
Joined: 21-Feb-2006

We have a database on UDB which is sourced from multiple systems.  We only see a way to map 1 table and 1 column to a target table and column.  Anyone have any ideas on how we could show multiple sources of data for a table column other than just typing it all free form into one description field?
Report this to a Moderator Report this to a Moderator
 28-Jul-2006 11:25
User is offline View Users Profile Print this message


Mark Studden

Posts: 4
Joined: 5-Jul-2006

You will need to create some custom objects (ie extend your metamodel to include mappings linking Columns to other Columns) and relationships. We have objects called Mappings, which in turn contain objects called 'Column Source' and 'Column Target', each of which associates a Column from one Table with a Column from another Table, allowing us to record many-to-many mapping information. In other words, one or more (Source) Columns from one or more (Source) Tables may be mapped to one or more (Target) Columns in one or more (Target) Tables. Each Table may be associated with one or more Mappings; i.e it may be built using one or more sets of mapping information (ETL code). It's a bit more complex than that, but you get the drift. Start hacking that USERPROPS file!
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.