Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Query on preprocessor Additionaltable execution

rameshm
New Contributor III
New Contributor III

Hello Experts,

Can you please help me to understand, how many times the ADDITIONALTABLES gets executed during a single import job. Does it executes again and again per record?

In case any customProperty is getting updated and if we are having same customproperty used as part of ADDITIONALTABLES, would the currentUsers table will have updated value?

Thanks in advance.

Regards,

Ramesh

2 REPLIES 2

itinjic
Regular Contributor
Regular Contributor

During a single import job, the ADDITIONALTABLES section is executed only once. It is used to prepare the dataset on which the preprocessor queries will be run. The result of the queries is stored in temporary tables, which are then used in the preprocessor queries.

In the case of updating a customProperty that is also used in the ADDITIONALTABLES section, the value in the currentUsers table will not be automatically updated. The ADDITIONALTABLES section is executed before the preprocessor queries, so any updates made during the import job will not be reflected in the temporary tables.

If you want to update the value in the currentUsers table, you will need to include a preprocessor query that updates the customProperty in the currentUsers table based on the updated value in the imported data.

If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

rushikeshvartak
All-Star
All-Star
  • It creates temporary tables and select query is executed once but update query is ran per user

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.