Can't find a proper join when attempting to join a custom subject area to an augmentation table.

Question

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!

Sumanth V -Oracle · Accepted Answer

@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!.

JDCal · Accepted Answer

Makes sense, thanks Sumanth!