Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Can't find a proper join when attempting to join a custom subject area to an augmentation table.

I am very new to FDI. I am trying to bring data from the augmented table (Job Application History Event Details - Contains all history for job applications states phases) into a custom subject area I created - from The Talent Acquisition subject area in FAW. I found multiple identifiers in the augmented table, but all the identifiers from the augmentation table are numeric and the ones from the custom subject area are doubles. I can't find out any information related to this.
Are you only supposed to only join on entity keys?
Thanks very much!
Best Answers
-
@JDCal - The best practice is always to join on entity keys as unique value identifying each row in table would help avoiding data consistency errors when doing the analytics. Thanks!.
0 -
Makes sense, thanks Sumanth!
0