Skip to Content
0
Former Member
Feb 17, 2009 at 12:24 PM

Multiple access or multiple statement

51 Views

In our scenario we have multiple records coming from SAP and we have to INSERT into Database.

We have modeled a XML-SQL jdbc document format in the target data type. There is one issue that we need to clarify here.This would be regarding the occurence of the the STATEMENT node vis-a-vis the ACCESS node.Two options which we have are:

1) Make the Statement unbounded and access as occurrence 1. Generate a new statement for each record and map the access for each record.

2) Make the Statement as 1..1, and make the ACCESS as 1..unbounded. The next step would be to generate the ACCESS node as many times as the number of records to be inserted.

Is there a difference here? or is there an advanatage or disavantage among the above two options.