![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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?
|
|
![]() |
|
![]() |
|
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!
|
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.