How to join Talent Acquisition Logical Star with Age Band Dimensions in FDI?

Question

I am working with Fusion Data Intelligence (FDI) and I need to create a report in Talent Acquisition that includes Age Band distribution for candidates/applicants.

I am looking for the best way to link the Logical Star for Talent Acquisition (specifically around Job Applications/Candidates) with the correct dimension for Age Bands.

Does the Talent Acquisition Logical Star already include a dimension where Age Band values are stored?

Which Dimension should I join with the Talent Acquisition Fact table to retrieve the Age Bands?

Thanks

Claudia

Raghavendra Raghunath-Oracle · Answer

Hi @ClaudiaManea I checked internally, and there is no equivalent table for this in ADW

Raghavendra Raghunath-Oracle · Answer

sure, let me check with the engineering team and get back to you on this

ClaudiaManea · Answer

Thanks @Raghavendra Raghunath-Oracle

:)

I am trying to replicate the dynamic behavior of the 'Worker Age Band' from Workforce Core in a custom SQL query for Candidates.

While OAC uses the metadata view OAX$OAC.RC_CONTENT_PARAM_BAND, this isn't accessible or populated for SQL users in our instance. Since these bands are maintained in the FDI Console, they must be persisted somewhere in the OAX$DW schema to be used in ETL or Star Schemas.

Could you confirm which physical table in ADW (OAX$DW) holds the activated configuration for BAND_NAME = 'Worker Age Band'? I am looking for the DWH source of MIN_RANGE, MAX_RANGE, and RANGE_LABEL so I can join it with my fact tables dynamically.