Skip to main content
Solved

Incremental Load Issue

  • March 19, 2024
  • 1 reply
  • 76 views
A
Do Gooder (Partner)
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/

1 reply

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

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/


Terms & ConditionsCookie settingsAccessibility statement