This content has been marked as final. Show 6 replies
If you are receiving the changes from PeopleSoft, couldn't run an automater(action script) to load the changes into DRM? I am not sure why you would need to import/blend.1 person found this helpful
I may be missing something in your question.
I was told that, I will be receiving the whole hierarchy and not just the new changes, I am in middle of an already designed project.
Please correct the following statements, if I am wrong.
1) If I receive the whole hierarchy, I need to import and blend.
2) If I just get the new changes list, I can always do an automator.
1)You are correct. Another option is load the PeopleSoft hierarchy and the DRM hierarchy into a database, then compare the two hierarchies to get the changes. Once you have the changes, you could load them into DRM. This option may not be that great if you have to perform the comparison on several hierarchies, but it is another option.
2)This is correct.
Import and blend is only the best option... You can control out of DRM to export only new changes but not in to the DRM. As source (People soft) does NOT operate based on the DRM..1 person found this helpful
If you have Oracle/SqlServer in place a simple procedure will do the needful, you consider the whole extract you receive from PSFT onto a table ( Ex: STG_SOURCE) using External table concept and also maintain the same in a backup table (Ex:BKP_STG_SOURCE) after the first execution, from the next subsequent executions it will take care by comparing the BKP_STG_SOURCE and STG_SOURCE tables, which is a simple solution with which you can avoid creation of new versions ( from Import process) and blending the whole hiearchy on a daily basis will impact your system performance.