Hello All,
I am refactoring out SSIS ETLs those are pulling data from AX to Data Warehouse (DWH). Currently these ETLs are doing Full Load. On Each Run It is TRUNCATING destination tables in DWH and loading everything.
Full load process taking hell of time and these need to be converted to DELTA or INCREMENTAL load. But unfortunately, not all the tables in AX has ModifiedDateTime and CreatedDateTime.
Would like to know how other people are processing DELTA from AX?
Hi Shivendoo,
You need to enable the fields Created / Modified date time. Once enabled all existing records will get assigned a date. Then on go-forward basis you should be able to do Delta insert/updates. If the records get deleted in these tables, then you have to track that separately as well.
Thanks,
Satish Panwar
Please take time to click yes against the answer that help guide you in right direction.
Hi Satish,
Thanks for your response. I am new to AX. Would you mind explaining how to enable Modified and Created DateTime on each and every table? Is there any T_SQL script to do so..? Also by enabling these fields can cause performance issue..?
It has to be done always through AX. Launch ax, go to AOT. Select table and view properties. Then again the property createddatetime / modifieddatetime and set them to yes. Synchronization the table and you should be good. This Needs to be done in Dev environment, test everything and then promote to next set of environments.
Enabling these dates in AX will add the fields in SQL directly. If you don't know what AOT is, reach out to Dev who would know this better. If not search google. You would need to learn a bit before you can do this and start moving across environments.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,047
André Arnaud de Cal... 885 Super User 2025 Season 2
Sohaib Cheema 592 User Group Leader
