We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Data Augmentation not pulling data for some records
Hi,
I have created a data augmentation to get a column from OTBI to FAW.
Recently, I noticed that some records it is not pulling up the value, even though there is data on the frontend and in OTBI.
Can anyone help me understand or guide me what exactly I can check to get the issue.
Note: - PVO used - HcmTopModelAnalyticsGlobalAM.AssignmentAM.WorkRelationshipPVO
Thanks
Answers
-
Hi Ruvina, the common reason for some records not pulling via Data Augmention is when FAW marks them as duplicates based on primary key or rejects them due to null value - you will find them as Rejected records in Data Warehouse Refresh Subject Area.
ALSO you must ensure that any column with primary key doesn’t have null values, otherwise the extract process rejects the entire dataset or table. If there are multiple columns with primary keys, then you must ensure that none of those columns have null values. If any of them have null values, then Oracle Fusion Analytics Warehouse rejects the entire extraction job. If Oracle Fusion Analytics Warehouse rejects the extraction job, then the corresponding augmentation is also rejected.
Please use following steps from FAW documentation:
Thank you,
Rajesh L
0