Forum Discussion

HoneyGulati's avatar
HoneyGulati
New Contributor III
6 hours ago
Solved

Need to reset import validate load step via BR

Hi,

I am trying to load the data from a file into the cube (import validate load steps) via Business Rule and while I am able to load it successfully. I am not sure how to reset it if the job fails in between.

For instance: Data pulled from the file gets failed at validate step due to some transformation rule issue. Now if I trigger the rule again , it will not do anything as import step is already completed. I need it to reset clear the cache from stage and redo the load process again when the business rule is triggered.

Can you please assist? Below is the code being used

 

  • can you try this?

    Dim objLoadTransformProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ClearStageData(si, wfClusterPk, sourceId)

2 Replies

  • pranav46's avatar
    pranav46
    Contributor II

    can you try this?

    Dim objLoadTransformProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ClearStageData(si, wfClusterPk, sourceId)