This content has been marked as final. Show 4 replies
you can use search functionality of the forum. Here is one thread How to use transformation script to add FK to relational model
Well it's complicated there here you can find the steps How to create Foreign Keys in relational Model using Transformation feature
Edited by: Philip Stoyanov on Sep 12, 2012 2:23 AM
Thank you for your quick reply. I had searched, but I obviously wasn't using the right terms.
Looking at the code in that thread, I was able to create a foreign key, but it adds a column to the source table. Is there any way to create a foreign key without creating a new column? Or, failing that, how can I alter the FKAssociation object so that it points to a column of my choosing?
Looking at the second link, I tried using the addForeignKey method, but it triggers a script evaluation error. I'm assuming my types are wrong. My referred is obtained by target_table.getPK() and the list of colums is:
list = new List();
list.add(column) // where column is a Column object
Edited by: 958587 on 13-Sep-2012 03:42