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