Custom Lookup table (other than LKU/LKV)
Hi,
I know there are bunch of discussions about lookups, and sorry if this is a repeat question. My question is around populating lookup values that represent the groups in our target system. The usual method is to have a SchedulerTask that calls on the tcLookupOperationsIntf to load these groups into OIM DB which finally settles down in LKU/LKV tables. The problem I have is there could be 1000s of groups out in the target system and is it recommended to dump all of these in the standard OIM lookup tables? Is it efficient? If not, how do I create a custom lookup table, populate with group data, and manage it just like OIM does with regards to indexing, sequence ids etc. Do I have to write my own SQLs or OIM has any interfaces to handle these values?
Has anyone done similar things? Please let me know
Thanks a lot
SK