Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Check file exist and start mapping

User_84SZKFeb 28 2022

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?

This post has been answered by Rodrigo Radtke Souza on Mar 2 2022
Jump to Answer
Comments
Post Details