Versions: DSMA / ISA 6.x
Issue: When the IS repository is stored in Oracle, Build Package generates an invalid data flow. Taking the following table as an example:
The data flow generated in DataServices looks as follows (this cannot be exported as it is invalid):
And when you attempt to refresh the target table, DSP yields an error message similar to the following (as might be expected, given that the generated data flow is invalid):
The workaround is to delete the invalid source table (in this case: MMD_Connection_ISSAP) from the data flow and re-add it from the datastore ISSAP (attached as DF_ISSAP_dgRepository_IS_MMD_Connection.atl):
Having applied the workaround, target tables now refresh without error.