Skip to main content
  • EN

Table1

pTable2

table 2 

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.

Thanks for the response @Takashi Iijima​ 

I solved with two FeatureWriter and SQLExecutor.

Reply


Community Stats

30,354
Posts
115,364
Replies
38,091
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.