Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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