I would like to float the idea of removing SystemPhysical from the 6.3 release and converting System to a physical model. System as a virtual model needlessly introduces lookup tables and joins between the SystemPhysical tables. Also SystemPhysical is filled with a lot of modeling and indexing concepts that would be best not to expose. Since SystemPhysical is marked as non-visible, not documented for use (from within transformations), and has all of its relevant information exposed through System anyway the impact and potential workarounds for this removal are minimal. Let me know if there are any concerns.
Sorry if I missed this in the documentation, but I have the following
When designing my VDB in the Designer, I have to tell the connector(s) I
am using where to find the sources. So in case of a Text File Connector,
I would have to tell it the location of the text file.
This is most likely going to be a different path and filename in my
development environment than what it is going to be later in production.
But how would I be able to pass a parameter with the text file location
(Text File Descriptor) to the JDBC connection to my VDB from my application?
I hope I was able to explain what I mean. Any pointers are appreciated.