venkatasuryadwh

 Profile Answers by venkatasuryadwh 

• Dec 16th, 2008

 

Use sql overide to capture the change data capture which looks like this..... 

(
 EFF_FROM_DATE >= $$LAST_RUN_DATE
 AND 
 EFF_FROM_DATE < TO_DATE('$$$SessStartTime', 'MM/DD/YYYY HH24:MI:SS')
 )
   OR
   (
    EFF_TO_DATE >= $$LAST_RUN_DATE
    AND
    EFF_TO_DATE < TO_DATE('$$$SessStartTime', 'MM/DD/YYYY HH24:MI:SS')
   )