Feb 15, 2017 at 10:37 AM

SAP Data Services Optimized Query Generation

103 Views Last edit Feb 15, 2017 at 11:03 AM 2 rev

Hi Guys.

Facing a strange issue wherein as long as I am using pushdown_sql in the where clause I am getting as expected the correct optimized query being generated as below:

INSERT INTO SDA_GAL_CONTRACT_CUSTOMER ( CDCOUNTRY , CDSTORE , NRYEAR , IDCUSTOMER , CDSTATUS , CDCONTRACT , IDCONTRACT , ETL_CHG_CD , ETL_JOB_RUN_ID , ETL_WRKF_RUN_ID , ETL_JOB_EXEC_DTTM , ETL_JOB_END_DTTM , SRC_SYS_CD , WHS_LD_TMST , RGN_IN ) 
SELECT  S_GAL_CONTRACT_CUSTOMER.CDCOUNTRY  AS CDCOUNTRY ,  S_GAL_CONTRACT_CUSTOMER.CDSTORE  AS CDSTORE ,  S_GAL_CONTRACT_CUSTOMER.NRYEAR  AS NRYEAR ,  S_GAL_CONTRACT_CUSTOMER.IDCUSTOMER  AS IDCUSTOMER ,  S_GAL_CONTRACT_CUSTOMER.CDSTATUS  AS CDSTATUS ,  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  AS CDCONTRACT ,  S_GAL_CONTRACT_CUSTOMER.IDCONTRACT  AS IDCONTRACT ,  $G_ETL_CHG_CD_U  AS ETL_CHG_CD ,  $G_JOB_RUN_ID  AS ETL_JOB_RUN_ID ,  $L_WF_RUN_ID  AS ETL_WRKF_RUN_ID ,  $G_JOB_EXECUTION_DATETIME  AS ETL_JOB_EXEC_DTTM ,  $G_JOB_END_DATETIME  AS ETL_JOB_END_DTTM ,  S_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  AS SRC_SYS_CD ,  $G_WHS_LD_TMST  AS WHS_LD_TMST ,  S_GAL_CONTRACT_CUSTOMER.RGN_IN  AS RGN_IN
FROM S_GAL_CONTRACT_CUSTOMER S_GAL_CONTRACT_CUSTOMER INNER JOIN SDA_GAL_CONTRACT_CUSTOMER SDA_GAL_CONTRACT_CUSTOMER ON ( S_GAL_CONTRACT_CUSTOMER.CDCOUNTRY  =  SDA_GAL_CONTRACT_CUSTOMER.CDCOUNTRY ) AND
 ( S_GAL_CONTRACT_CUSTOMER.IDCUSTOMER  =  SDA_GAL_CONTRACT_CUSTOMER.IDCUSTOMER ) AND
 ( S_GAL_CONTRACT_CUSTOMER.NRYEAR  =  SDA_GAL_CONTRACT_CUSTOMER.NRYEAR ) AND
 ( S_GAL_CONTRACT_CUSTOMER.IDCONTRACT  =  SDA_GAL_CONTRACT_CUSTOMER.IDCONTRACT ) AND
 ( S_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  =  SDA_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD ) AND
 ( S_GAL_CONTRACT_CUSTOMER.RGN_IN  =  SDA_GAL_CONTRACT_CUSTOMER.RGN_IN ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  =  $G_SRC_SYS_CD ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.RGN_IN  =  $G_RGN_IN ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.ETL_WRKF_RUN_ID  =  $L_WF_RUN_ID )


 where 
(
   (
          (SDA_GAL_CONTRACT_CUSTOMER.cdStatus <> S_GAL_CONTRACT_CUSTOMER.cdStatus) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdStatus IS NULL AND S_GAL_CONTRACT_CUSTOMER.cdStatus IS NOT NULL) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdStatus IS NOT NULL AND S_GAL_CONTRACT_CUSTOMER.cdStatus IS NULL)
    )
	OR
		(
          (SDA_GAL_CONTRACT_CUSTOMER.cdStore <> S_GAL_CONTRACT_CUSTOMER.cdStore ) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdStore  IS NULL AND S_GAL_CONTRACT_CUSTOMER.cdStore  IS NOT NULL) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdStore  IS NOT NULL AND S_GAL_CONTRACT_CUSTOMER.cdStore  IS NULL)
        )
				OR
		(
          (SDA_GAL_CONTRACT_CUSTOMER.cdContract <> S_GAL_CONTRACT_CUSTOMER.cdContract) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdContract  IS NULL AND S_GAL_CONTRACT_CUSTOMER.cdContract  IS NOT NULL) OR
          (SDA_GAL_CONTRACT_CUSTOMER.cdContract  IS NOT NULL AND S_GAL_CONTRACT_CUSTOMER.cdContract IS NULL)
        )
		 )

Looking at a dataflow it looks to be a simple one with 2 tables being joined in single query transform but as soon as the pushdown sql is removed the optimized query gets vague as below:

INSERT INTO SDA_GAL_CONTRACT_CUSTOMER ( CDCOUNTRY , CDSTORE , NRYEAR , IDCUSTOMER , CDSTATUS , CDCONTRACT , IDCONTRACT , ETL_CHG_CD , ETL_JOB_RUN_ID , ETL_WRKF_RUN_ID , ETL_JOB_EXEC_DTTM , ETL_JOB_END_DTTM , SRC_SYS_CD , WHS_LD_TMST , RGN_IN ) 
SELECT  S_GAL_CONTRACT_CUSTOMER.CDCOUNTRY  AS CDCOUNTRY ,  S_GAL_CONTRACT_CUSTOMER.CDSTORE  AS CDSTORE ,  S_GAL_CONTRACT_CUSTOMER.NRYEAR  AS NRYEAR ,  S_GAL_CONTRACT_CUSTOMER.IDCUSTOMER  AS IDCUSTOMER ,  S_GAL_CONTRACT_CUSTOMER.CDSTATUS  AS CDSTATUS ,  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  AS CDCONTRACT ,  S_GAL_CONTRACT_CUSTOMER.IDCONTRACT  AS IDCONTRACT ,  $G_ETL_CHG_CD_U  AS ETL_CHG_CD ,  $G_JOB_RUN_ID  AS ETL_JOB_RUN_ID ,  $L_WF_RUN_ID  AS ETL_WRKF_RUN_ID ,  $G_JOB_EXECUTION_DATETIME  AS ETL_JOB_EXEC_DTTM ,  $G_JOB_END_DATETIME  AS ETL_JOB_END_DTTM ,  S_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  AS SRC_SYS_CD ,  $G_WHS_LD_TMST  AS WHS_LD_TMST ,  S_GAL_CONTRACT_CUSTOMER.RGN_IN  AS RGN_IN
FROM S_GAL_CONTRACT_CUSTOMER S_GAL_CONTRACT_CUSTOMER INNER JOIN SDA_GAL_CONTRACT_CUSTOMER SDA_GAL_CONTRACT_CUSTOMER ON ( S_GAL_CONTRACT_CUSTOMER.CDCOUNTRY  =  SDA_GAL_CONTRACT_CUSTOMER.CDCOUNTRY ) AND
 ( S_GAL_CONTRACT_CUSTOMER.IDCUSTOMER  =  SDA_GAL_CONTRACT_CUSTOMER.IDCUSTOMER ) AND
 ( S_GAL_CONTRACT_CUSTOMER.NRYEAR  =  SDA_GAL_CONTRACT_CUSTOMER.NRYEAR ) AND
 ( S_GAL_CONTRACT_CUSTOMER.IDCONTRACT  =  SDA_GAL_CONTRACT_CUSTOMER.IDCONTRACT ) AND
 ( S_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  =  SDA_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD ) AND
 ( S_GAL_CONTRACT_CUSTOMER.RGN_IN  =  SDA_GAL_CONTRACT_CUSTOMER.RGN_IN ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.SRC_SYS_CD  =  $G_SRC_SYS_CD ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.RGN_IN  =  $G_RGN_IN ) AND
 ( SDA_GAL_CONTRACT_CUSTOMER.ETL_WRKF_RUN_ID  =  $L_WF_RUN_ID )


 where ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S_GAL_CONTRACT_CUSTOMER.CDSTATUS ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  IS NOT NULL )) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  <>  S_GAL_CONTRACT_CUSTOMER.CDSTORE ) or ( S_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL )) or ( SDA_GAL_CONTRACT_CUSTOMER.CDSTORE  IS NOT NULL ))) or ((( SDA_GAL_CONTRACT_CUSTOMER.CDCONTRACT  <>  S_GAL_CONTRACT_CUSTOMER.CDCONTRACT ) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NOT NULL )) or ( S_GAL_CONTRACT_CUSTOMER.CDCONTRACT  IS NULL ))) and ((((( SDA_GAL_CONTRACT_CUSTOMER.CDSTATUS  <>  S

Anyone has any idea as I am using Teradata as source and target.

Cheers.

Shaz