Description
My client is looking for a consultant with experience in data modelling and experience with Sybase Power Designer. The ideal candidate can work remotely if necessary.
Description:
1) Identify in the workspace the model corresponding to the associated TDM.
2) For each package without related diagram, the script checks in the TDM model if a diagram has the same name. If it is the case, the diagram is added as related diagram to the package.
3) For each process in the package, the script verifies that there is no related diagram. If it is the case, the script checks in the TDM if a data transformation task has the same name. If it is found, the diagram of this transformation task is added as related diagram to the process.
4) Remark: the processes in the DFM that are shortcut in a package are skipped because the related diagram is found in the target object of the shortcut.