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
;