[ODI 12c] Repository query for detecting enabled Knowledge Module options

kovar

Hi there,

currently I'm dealing with a large amount of ODI mappings that need to be checked after deployment, among other things, the physical layer. In particular, I am interested to see if the Knowledge Module options inside specific mapping are correctly set or are they potentially missing some checkbox tick.

For example, let's say I have a mapping that needs to perform TRUNCATE over a target table before the INSERT statement through an dedicated IKM. Is there a way to write a repository query that could gather me info if the IKM inside specific mapping has the truncate target table option turned on or off? E.g. 1 (active) or 0 (inactive) values like is_frozen option has in SNP table.

I found some info about KMs through SNP_TRT, SNP_LINE_TRT, SNP_LINE_TRT_UE tables but I don't see a clever way to join that info with SNP tables that containt info about mapping/package/scenarions.

The only thing I can think of at the moment is to check in SNP_SCEN_TASK.DEF_TXT if the truncate option is performing, but there must be a better way.

I hope you can help me.

Thanks in advance!

kovar