![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Mapping Columns to Columns Topic Summary: Easy mapping from a column in one table to a column in another table Created On: 11-Jun-2008 14:22 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hi,
I want to do some easy mapping of columns in 2 tables. I could define an object to hold the source and target tables and a sub-object to hold the source column and the target column plus any mapping info. In the sub-object, For the source column, I want to choose columns from the source table only. For the target column, I want to choose columns from the target table only. Otherwise it will takes ages. Any ideas on how to do this? Or a better of way of mapping interfaces. Thanks. Edited: 11-Jun-2008 at 14:27 by Arif Hussain |
|
![]() |
|
![]() |
|
This is something that needs to be designed in to your encyclopaedia and your modelling standards from day 1. Any retrofitting will give you a sub optimal solution.
I would imagine that part of the problem is having to reverse engineer the DDL for packages which don't map directly onto your own logical models. I use a "Data Set" object to hold the format of an interface, each item of content can then be mapped both to the columns that implement it and to the logical data elements that they represent. It isn't ideal but works pretty well. Give me a call if you want to chat about this in more detail. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.