Once you have verified that all required DM setup tasks have been successfully completed, you can perform three simple tests to ensure that your flows will run properly. We created some sample data and process flow procedures for you to use in testing your setup.
We recommend that you run these tests before you create and attempt to run your own flows.
This data flow extracts the department ‘Production’ data from the data source named employe2 and creates a new data target, also named dmvpx.
(ICM18763) Request ibisamp/dmvpx complete
The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log, which is displayed in the workspace, indicates that the new table named dmvpx has been created and loaded with six rows.
This example assumes that you have already completed Testing the Sample Data Flow DMVPX, since it uses a table that you create there.
This data flow extracts the records for the department 'MIS' from the data source named employe2 and adds them to the existing table dmvpx.
(ICM18763) Request ibisamp/dmvpy complete
The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log in the workspace shows that the target table exists and that six records for the MIS department were added to the target.
The data flows that ran separately in Testing the Sample Data Flow DMVPX and Testing the Sample Data Flow DMVPY now run as a combined process flow.
This process flow sets up the flow of dmvpx followed by dmvpy.
When the process flow runs, the first data flow creates the new table and the second data flow loads it with additional records.
(ICM18763) Request ibisamp/dmvpz complete
The Log and Statistics dialog box opens. From the Report Type drop-down menu, select Log and then click the View Report button. The log in the workspace shows that the two data flows ran successfully.
Next Steps: If you have received these results, you can feel confident that your client/server setup is running correctly and you can proceed to the design phase.
If you are not familiar with DM processing, we urge you to read Planning a DataMigrator Application, before you begin creating flows to ensure that you make optimal decisions about such issues as data structures and security to meet the needs of your site.
iWay Software |