hi folks,i want to implement incremental load on one table using Date

[Anonymous]

hi folks,i want to implement incremental load on a table using Date.the data is coming from SAP .

this is the code:

FACT_MaintenanceOrderHeader:  

NoConcatenate

Load

   //AUFNR & MANDT AS %KEY_AFIH_AUFNR_MANDT,

  // [MANDT] as [Client_MANDT],

   [AUFNR] as [Order_AUFNR],

   [QMNUM] as [Notification_QMNUM],

   [EQUNR] as [Equipment_EQUNR],

   [PM_OBJTY] as [Object category_PM_OBJTY],

   [ILART] as [MaintActivType_ILART],

   [ABNUM]   AS [Call Number_ABNUM],

   [WARPL] AS MaintenancePlan_WARPL;

SQL Select MANDT AUFNR QMNUM EQUNR DEVICEID IWERK PRIOK ANLZU ADPSP ILOAN REVNR ARTPR BAUTL ILOAI INGPR APGRP PM_OBJTY GEWRK KUNUM ANING GAUZT GAUEH ANLBD ANLVD ANLBZ ANLVZ INSPK DATAN WARPL ABNUM WAPOS LAUFN OBKNR ADDAT ADUHR IPHAS ILART HISDA AKKNZ PLKNZ SERIALNR SERMAT SCREENTY /ISDFPS/OBJNR /ISDFPS/MEQUI  from AFIH

;