We're currently looking to build a process to move data from Infomart to our data warehouse. We're planning to build the trigger off CTL_AUDIT_LOG to allow us to get it near realt time, but our DBA's have asked the question on what the PROCESSING_STATUS_KEY value represents in this table. Fair question. Unfortunately, the documentation says it is a key to the CTL_PROCESSING_STATUS dimension table and that table in our deployment is empty (Documentation also says this field is reserved, so guessing it's meant to be at the moment?) Is there anywhere to get a list of the values?
Info Mart Schema version is 8.1.300.014