Hello everyone, is it possible to check whether a file exists in the loading plan using the variables or CASE WHEN conditions?
Then I would like to start a mapping if the file is available.
Currently I'm running the mapping which takes the file and imports it( in exception mode - throw no error). But I would like to have the exception so that the loading plan breaks off at the beginning if the data is corrupt.
I would like to do this in the loading plan, since it is possible to see the inserted data records here. Is this possible and if so how?