We have prepared individual IOK Files for each flat file which contains data from different modules. Now we are planning to combine all these IOK Files and make them as a single IOK and all the flows will be created one after the other. How can we control the sequence of the processing? Once the flow in one flat file is completed, then it should process the second flat file since for some flat files there is some linking and it requires data from the initial flat file.

Suppose we have employee , department & salary data. Initially we had prepared individual IOK Files and were running in the desired sequence Department --> Employee --> Salary . But now, we want to combine them to a single IOK File. Are we be able to control the sequencing in the Omniscope DataManager?

Also attached the sample IOK File into which we are importing Emp, Dept & Salary Data and at the last all the info from tables is joined and Excel output is generated from the custom SQL. Can we control sequencing here, so that the custom SQL runs last, after all the data from the flat files has been uploaded to the Oracle tables?

Thanks, Suresh.