Unfortunately that's not built-in functionality.  See https://issues.jboss.org/browse/TEIID-2253 for multi-source issues that could be updated to include this one.  The workaround for a dynamic vdb would be to use a custom metadata repository - https://docs.jboss.org/author/display/TEIID/Custom+Metadata+Repository - that add the source name coulmn to each table.

Steve

You can do either one of them. If choose to decorate existing source medatadata, you would need to submit a comma separated list of the repositories in the

        <metadata type="NATIVE,MYMODULE">

        </metadata>

Yes, you would just decorate.  The logic would look something like:

public void loadMetadata(MetadataFactory factory, ExecutionFactory<F,C> executionFactory, F connectionFactory) throws TranslatorException {

  for (Table t : factory.getSchema().getTables().values()) {

    factory.addColumn("SOURCE_NAME", "string", t);

  }

}

You would just add the custom repository as the last one to modify the metadata that was already loaded.