QuestionQ20

Scripting and Automation

A developer must import a file each night for use by multiple SQL Query Activities. The file may arrive at any time between 2 a.m. and 5 a.m., and a requirement is to use a unique filename for every import instead of overwriting the file on the FTP site.

Which action should be configured?

  • A File Drop Automation
  • B Scheduled Automation
  • C Dynamic File Import
Explanation

A File Drop Automation monitors an Enhanced SFTP directory or a specified filename pattern and starts when a matching file is uploaded. This supports files that arrive at an unpredictable time and allows each import file to have a unique name while matching a common pattern.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!