Problem with ORCHESTRATE

just4u_sharath · Post by **just4u_sharath** » Tue Mar 11, 2008 11:44 am

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
)

ArndW · Post by **ArndW** » Thu Mar 13, 2008 3:31 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2008 3:34 am

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.