Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Audit Framework for Data Load from SFTP

Needs Votes
11
Views
0
Comments
User_1PN2S
User_1PN2S Rank 2 - Community Beginner

We are using SFTP data source. When the data is loaded, there is no log of any failures,

As an data steward I should be able to verify that all the rows in my source files have loaded into the target database table. I should be able to see the reason for rejection.

I should be able to run the data load in verification mode to ensure that all the rows will load correctly and to correct any data load issues before running the data load in update mode.

I should be able to see the number of rows that will be effected by each error code.

1
1 votes

Needs Votes · Last Updated