I've just started a 14-day evaluation of FME, and would appreciate
any quick help on this subject to avoid me spending the whole period
trawling in vain through manuals and user groups.
I'm translating from GML to Oracle 8i (attributes only), and I'm
only interested in a small number of features (Roads, RoadLinks and
RoadNodes to be precise). It all works fine up to a point, in that I
can easily import from a GML file and see the corresponding Oracle
tables get populated. Thus, for example, it will populate an Oracle
table ROADS whose contents have a one-to-one mapping with the Road
features in the source GML.
The question I have concerns what to do about feature attributes
that represent multiple values. For example, the Road feature in the
source dataset has an attribute NetworkMember{}, which represents
0..n values. At the moment, my translation does nothing with this
attribute - that is, in the destination Oracle table there is a
column NETWORKMEMBER{} which is always null regardless of the fact
that the source data generally contains >0 values.
General question: How do I copy the multiple values across to the
destination dataset?
Specific question: I really want to translate an attribute like this
into a separate Oracle table of its own, to give me a better 'RDBMS-
type' view of the source data. Thus, rather than the single feature
attribute being mapped to a single Oracle table column, a new table
(e.g. ROAD_NETWORK_MEMBER) would be used to represent this
multiplicity (e.g. with columns ROAD_ID, NETWORK_MEMBER). Can I do
this? If so, how?
Apologies for any non-standard terminology. Any advice gratefully
received.
Thanks
Simon
Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC
Canada. For more information, visit www.safe.com/2006uc.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
