Skip to main content
Solved

Incremental Load Issue

  • March 19, 2024
  • 1 reply
  • 64 views

Forum|alt.badge.img+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

Best answer by subashfestus

Hi @AccManisC,

This is how you can recreate the access views to use the Datamart view instead of the Online view.

https://docs.ifs.com/techdocs/23r2/050_reporting/256_br_and_a/050_integrations/080_external_access/010_access_views/010_cremanageaccessviews/

Also, refer to the following docs to configure the incremental loading of datamarts for supported facts.
https://docs.ifs.com/techdocs/23r2/050_reporting/500_information_sources/050_data_mart_access/010_overview/015_incr_load_of_is/
https://docs.ifs.com/techdocs/23r2/050_reporting/500_information_sources/050_data_mart_access/040_handling_incremental_load/

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img+7
  • Hero (Employee)
  • 52 replies
  • Answer
  • March 20, 2024

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings