Timestamp Based Data ingestion in AEP
We are using CSV based data ingestion from ADSL 2.0 source connector. There is a field called lastUpdatedDate which is datetime field. Normal ingestion is working fine. But I want to do ingestion based on the lastUpdatedDate field. Issue I am facing is the source system is not able to send me incremental file and always sends full file. So i need to ingest only those records whose lastUpdatedDate field is newer than one we have.. This feature exists in some form in DB connectors but not present by defualt in CSV based ingestion. Possible reason for this is when we are ingesting the data from CSV and setting up rules, we dont have access to AEP dataset and hence can not figure out last updated timestamp to compare… Let me know if this is possible in some way.
Regards, Kishor