Hi Francesco, That's not much information to go on, and I can't think of any tool in Workbench that will join items without a known linkage.
I'm struggling to remember but I think the linkage within an SQD file is called enum - if you have an attribute like that try to find similar values in your Oracle database. Won't that field have an index on it? What you could do is use the ChangeDetector or Matcher transformers in Workbench to try and match records based on what you think is a common attribute. If you get a lot of matches then you can be fairly certain you have found the join - at least these transformers are a bit more forgiving than the Joiner. Besides that simply loading the data into FME Viewer may help you to determine how the linkage has been formed. If you are really stuck then you could purchase some Solutions Assistance time from our Professional Services team who would be able to look at your data and make suggestions. You can find more info on this service at www.safe.com/services How did you get in this situation anyway? I thought that Sicad was self contained in Informix and that an SQD file would also hold all the attribute information; or am I wrong? Hope this helps; good luck Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of radiothom2005 Sent: April 29, 2005 12:44 AM To: [email protected] Subject: [fme] Re: Sicad SQD to Shapefile Thank you, Mark. The problem is that i don't know how the spatial data are joined with the alphanumerical data stored in oracle tables and i have to export both data in shape file format. any suggestion will be appreciated Regards, Francesco --- In [email protected], "FMEList" <[EMAIL PROTECTED]> wrote: > > Can you give us some more details on the specific problems you are > facing? > > I don't know if the Sicad reader will also read from Oracle, so you > may have to add a reader for both and use a FeatureMerger or add a > Sicad reader and use a Joiner transformer to connect them to the > Oracle records. > > Regards, > > Mark > > Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, > CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data > Translation, Distribution and Access > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > radiothom2005 > Sent: April 21, 2005 12:44 AM > To: [email protected] > Subject: [fme] Sicad SQD to Shapefile > > > > > Hello! I'm trying to convert a Sicad file (Sqd) with attacched data in > oracle tables to an Esri shape file but i have some problems to do this. > Can someone help me in this job? > radiothom > > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect > via our Professional Services team. Visit www.safe.com/services for > details. > Yahoo! Groups Links Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. 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/
