Data Discrepancies in Reporting Due to Issues with SIL_EMPLOYEEDIMENSION Incremental Load Not loading into Target Dimension
Last updated on AUGUST 09, 2016
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 [AN 1900] and later
Information in this document applies to any platform.
There is a difference in the staging data and the dimension data for W_EMPLOYEE_D and W_EMPLOYEE_DS for the column HELD_POSTN and PR_POSTN columns. Staging has the right data and that data isn't being updated in target dimension for HELD_POSTN and PR_POSTN columns in incremental load.
This is causing data discrepancies in our reporting
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms