How to build the process in datastage
Posted: Thu Jan 15, 2009 5:51 pm
Hi Everyone,
We have datastage process that needs to start once after finishing some other process on different server. Lets say process 1 on server A and process 2 ( Datastage ) on Server B. Once the process 1 finishes they will update one of their target table with the current date. Then i need to compare that target table with one of my table and if the newer date is found i need to pull the data from their process. ( I need to start my datastage process) .. Could anyone suggest how to build this process in datastage .. Since i have done using the waitforfile activity stage but not by comparing the table,looking up the date field, looping mechanism etc.
I have searched the forum and found some useful posts .. It would be great if i could get some inputs on this.
Thanks in Advance
We have datastage process that needs to start once after finishing some other process on different server. Lets say process 1 on server A and process 2 ( Datastage ) on Server B. Once the process 1 finishes they will update one of their target table with the current date. Then i need to compare that target table with one of my table and if the newer date is found i need to pull the data from their process. ( I need to start my datastage process) .. Could anyone suggest how to build this process in datastage .. Since i have done using the waitforfile activity stage but not by comparing the table,looking up the date field, looping mechanism etc.
I have searched the forum and found some useful posts .. It would be great if i could get some inputs on this.
Thanks in Advance