Does anyone know of a way to retrieve the Primary key columns in an interface (like getPKColList()) or just getCollist() but for a datastore that is not the target table ? ie its just some other datastore in the model.
I want to use it in an interface filter, trying not to hard code the column names.
If it doesn't work, you can still define a SCD properties on your source datastore and then use getSrcColList() with the SCD_COL_TYPE pattern. http://docs.oracle.com/cd/E14571_01/integrate.1111/e12645/odiref_reference.htm#CIAIIAAD
I don't remember, can you put flexfield on columns ? If yes, it's still another solution.
Not using a CKM at present - this is for use in an interface filter.
Hmmm flex fields are available on columns, i will try and tag the source table SCD_NK atrributes , and use a flex field on those columns to map the corresponding remote table . column I want to use in a filter.