JDBC connector Account to Entitlement Mapping Issue

sai_krishna_L · April 30, 2025, 10:56am

Hi Team,

Problem statement : Entitlement is not getting mapped to the account. Attached all the required queries and snippet of schemas.

Account query :

SELECT sausr,ghid FROM RMTFIL.SAUSRP left join RMTFIL.SAGRHP on saacnt = ghid WHERE SALEVL = ‘GR’ AND SAACNT in (‘USRDR’,‘SUPUPD’)

Entitlement query :

SELECT GHID , GHDES FROM RMTFIL.SAGRHP
WHERE GHID in (‘USRDR’,‘SUPUPD’)

Account Schema:

Entitlement Schema:

Kind Regards,
Sai Krishna L

srezzaki · April 30, 2025, 3:18pm

Why the GHID is marked as entitlement in the entitlement schema ?

sai_krishna_L · May 5, 2025, 4:50am

Hi Safae,

I was just trying different ways to map the entitlement to account. Even without GHID is marked as entitlement in the entitlement schema it’s not working.

Regards,
Sai Krishna L

Gopi2000 · May 5, 2025, 4:55am

Hi @sai_krishna_L

After those changes, did you try running an unoptimized aggregation?

sai_krishna_L · May 5, 2025, 5:13am

Hi Gopi,

I did try an unoptimized aggregation, but the expected output is not there. Can you let me know if the column names are different but with same value will that entitlement still map to the account?

Example:

Entitlement Columns:

GHID: USRDR
SAACNT: USRDR

Account Column:

SAUSR: 12345

Regards,
Sai Krishna L