Hi Team,
We have the below scenario:
Some list of files will be placed in a file location.
Till the last file streaming is completed i need to wait.
Then i need to read these extracts(these are very large files) and load into TABLES.
From SOA we can implement this using Trigger file and Minimum Age JCA properties in FileAdapter which internally invokes the ODI webservice.
But can we implement this functionality in ODI? If yes, then please let me know.
Or
We are also getting suggestions to use the ESS to schedule a job which invokes the ODI web service. But can we set the parameters in ESS to wait for the particular file in a share location and then invoke ODI service?
Thanks,
Kumar