DSXchange

Lookup Table is populated with data even after we truncate the table in Oracle.

Following is the user defined SQL in the Lookup table -

SELECT
Trim(EMPLID) as EMPLID,Trim(PERNR) as PERNR,TRIM(COMPANY_CODE) AS COMPANY_CODE,Trim(RFPRNR) as RFPRNR
FROM #$SCE_SSA_SCHEMA#.#JPM_MSTR_PERNR#
WHERE Trim(EMPLID)=ORCHESTRATE.EMPLID AND
(TRIM(COMPANY_CODE) =ORCHESTRATE.COMPANY_CODE
OR EMPL_RCD=ORCHESTRATE.EMPL_RCD
)

You posted SQL but didn't explain what the problem is.

It might also be a timing issue. After all, what you look up from is not the Oracle table itself, but the virtual Data Set associated with the link. Therefore, if the LUT_CreateOp operator had finished before you truncated the table in Oracle, all of the reference data would still be present in your job. It will disappear from memory when the job finishes.