Table1
Table2
Reader data from soap and writer is oracle spatial object.
I use inline querier and featureMerger for using xml hierarcy that is "STATUS_REASON_SEQ_ID ". So, I merged two tables and created. But I expect to see foreign key(references Table2 (SEQ_ID)) in Table1.
What should I use in this case. ?
Hi @ikubra800 , I think you can execute a SQL statement to add a foreign key to the Table 2 by setting the statement to the "SQL to Run After Write" parameter in the Oracle writer.
Alternatively, you can also execute SQL statements to create the destination tables including the foreign key constraint beforehand, by setting the "SQL to Run Before Write" parameter.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
