How to load the data which are dependent on each other in a sequence

[Priyanka Rai]

Hi

I have a use case where I am stuck.

We need to ingest data into different table (Account and Sim card table)

This use case is for 2 data loads into ServiceNow via transform maps executed in Flow designer.

I am loading an account data using transform map via flow designer everyday and we have approx 100k records daily.

Then I have another data load on sim card table.

The data must be loaded in the sequence to maintain referential integrity.

The 2nd  data load into the sim card table must happen only after the successful ingestion of account data and an email confirmation received from Snowflakes to proceed the data load.

1 I want  2nd transform map should only run when the first transform map for account is completed and email is received from snowflakes.

2How can I put a condition that only those CIs records should be created for which the account is loaded already?

3 How can I find which all records are skipped in both the transform map ( I know it can be checked in the import set but can it be done in more optimized way?

We can control when the 1st transform map will run but cant control the 2nd as it is also dependent on one email from snowflake which we will receive everyday at any time.