Oracle Transactional Business Intelligence Idea Lab

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

Sequential Bursting to be enabled in case of bursting multiple files

2
Views
0
Comments
user3927538
user3927538 Rank 1 - Community Starter

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Anixter Incorporated

Description (Required):

The ask is for Bursting multiple files one after the other. There are three files which needs to be bursted, two of which will be bursted first and the last file will be bursted after the first 2 are bursted. The last file will be a checkpoint which will signify that the rest 2 files are SFTP'd successfully.

Use Case and Business Need (Required):

The target system (Teradata) has a job that runs and checks for the file extension of the third file. If a file is present with the file extension of the 3rd file in the respective folder, only then it picks up the data and control file for processing. As of now, due to parallel bursting, the 3rd file which signifies the transfer completion gets SFTP'd first and then the data and control file gets SFTPd. Because of this the job ends in error since the Data and control file is not yet present in Target folder whereas the 3rd file is already bursted.

Enhancement Request / Service Request: 3-27081813161

1
1 votes

Submitted · Last Updated