Load Import Set data without Transfom Map

[AnkitaK37270321]

Does load data work with setworkflow (false)

I have a flow running on creation of records on staging table where im loading it. There is no transform map attached. The mapping is through the flow. This flow is not triggering. What could be the potential issue?

[Bhimashankar H]

Hi @AnkitaK37270321 ,

Are you loading the data from below attached screenshot i.e. load data.

or data source also will do same thing.

Once you loaded the data it will create insert data in staging table automatically. 

From staging table to target table you need to have at least one transform map with correct coalesce field.

The setWorkflow(false) is to not to run any flow, business rule for those inserted/updated record in target table.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[AnkitaK37270321]

Hello, yes that where im loading it from, the flow that i want to execute is also set to run on the same staging table on creation of records, then why is it not running?

[Bhimashankar H]

You mean to say @AnkitaK37270321  that flow is expected to run when you insert the record in staging table. 

Are records getting inserted in staging table? and the staging table is extended from import set table ?

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[AnkitaK37270321]

yes that's correct.

[Bhimashankar H]

Hi @AnkitaK37270321 ,

setWorkflow(true) will only run flows on target table not on staging table. The run script is when you are transforming data from staging to target table.

It is not best practice to run flows on staging table, it is just to ensure the data is in form to transform to target table.

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!