Sparse lookup with more than one key field

[swathi Singamareddygari]

Hi all,

I am doing sparse lookup in my job with 6 key fields with db2 database.

I gave the lookup query like this

SELECT
INTRACT_KEY_MAP_ID,CSS_FLD_ORGAN_ID,CSS_CLL_DT,CSS_CLL_TM,CSS_CLL_MICRO_SEC,CSS_PROV_ID_CLLR,CSS_PROV_ID_SEQ_CLLR,CCA_CNTCT_ID,CCA_INTRACT_NUM,CCA_REQSTR_INTRACT_CNTCT_ID,ERR_CNT,WARN_CNT
FROM
#$DMSYNC_SCH_NAME#.INTRACT_KEY_MAPNG
WHERE
CSS_FLD_ORGAN_ID= ORCHESTRATE.FLD_ORGAN_ID And
CSS_CLL_DT=ORCHESTRATE.CLL_DT And
CSS_CLL_TM=ORCHESTRATE.CLL_TM And
CSS_CLL_MICRO_SEC=ORCHESTRATE.CLL_MICRO_SEC And
CSS_PROV_ID_CLLR=ORCHESTRATE.PROV_ID_CLLR And
CSS_PROV_ID_SEQ_CLLR=ORCHESTRATE.PROV_ID_SEQ_CLLR

even though i am having matching records in the source and the reference table ,lookup is failing ,but the same thing is working with normal lookup.

can't we use more than on key column in the sparse lookup

if any one knows please help me

Thanks for your help