Solved

Incremental Load Issue

  • 19 March 2024
  • 1 reply
  • 30 views

Badge +2

Hello,

I have a requirement to make the data source - FACT_GL_TRANSACTION as incremental data load and I have modified that in Data Load Definitions -> Data Source ->FACT_GL_TRANSACTION - Incremental Load (condition got auto generated based on mvt_created_dt).

Although my existing access view FACT_GL_TRANSACTION_BI, has the data access type set as online and it is created based on FACT_GL_TRANSACTION_OL. Hence, full load will be sent every time when the data load runs as the mvt_created_dt in  FACT_GL_TRANSACTION_OL is sysdate.

I don't see any option to modify access view - FACT_GL_TRANSACTION_BI to change access type as datamart. Can you please suggest me how this can be handled

Regards,

Manisha

icon

Best answer by subashfestus 20 March 2024, 06:22

View original

Reply