Oracle Fusion HCM Analytics

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
22
Views
2
Comments
Rank 3 - Community Apprentice

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

  • Rank 8 - Analytics Strategist
    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!.

  • Rank 3 - Community Apprentice
    Answer ✓

    Makes sense, thanks Sumanth!

Welcome!

It looks like you're new here. Sign in or register to get started.