Read File in Segments to REST Service insert to ATP database
SummaryRead File in Segments to REST Service insert to database results in all rows written in each segment read
I have a very large file to import to my integration. I am using FTP download and then Stage Read File in Segments to access the data that will be inserted into a database table in our Cloud ATP Oracle database. The REST call is set up to utilize Batchload in order to post the 200 rows that each read in segment will pull.
The result is that for each read, All rows in the inbound file are written to the database. I believe the problem is in the way the elements are defined but cannot see that actual problem. I am very new to OIC and am learning on the fly. Any assistance will be appreciated.