How to control createTablePolicy of SQL tableReference that has a non-SQL sourceDirectory

[ron_1]

I have a SQLDirectory with a tableReference whose sourceDirectory is a MultiDirectory. I want to supply my own dataFile to populate the tableReference. How can I specify the createTablePolicy for the tableReference so that it will load the data in my datafile?

[Olivier_Grisel]

You can invert the relationship between the source multi and the target sql directories:

Put the TableReference to resolve the field of the SQLDirectory and put and InverseReference to resolve the field of the multi. That way the table reference should be initializable with the SQLSession of the SQLDirectory and hence it's dataFile attribute should be taken into account.

[ron_1]

Thanks.