Rank: Newbie
Joined: 12/7/2018 Posts: 1
|
Hi,
I am trying to map data from xml to postgres database. The database has a few link tables that resolve many-to-many relationship.
As an example, I use person and address tables with many-to-many relationship and then there is person_address bridge table with only two columns: personId(FK) and addressId(FK). Both personId and addressId are auto-generated by the database (or I can use max()+1 to fill it from mapforce).
If there was only one foreign key in the table then I would have resolved it by defining relationships in mapforce but I am a bit lost here in this case. I want to know how can I populate multiple foreign keys in a table coming from more than one tables?
Also all the relationships between the objects are defined in the xsd and once the data gets into the database I have no relationship track anymore.
Thanks in advance.
|
Rank: Advanced Member
Joined: 2/27/2009 Posts: 558
|
If the relationships for all these keys are not defined in the database and defining them locally in MapForce doesn't help, then it would probably be best to supply some example files with a portable database such as SQLite or Access. I would also suggest sending this directly to Altova Support.
|