This topic has been locked.
2 replies Latest Post - 2012-10-26T05:07:02Z by SystemAdmin
Pinned topic Infosphere Warehouse Design Studio Schedule facility
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
My team members are using ISW Design Studio for integrating data from another data source. This operation is scheduled using Schedule facility in the Design Studio. Sometimes, the data won’t be available and the scheduled flow is failed. In such situation, we wish to run the schedule automatically after some time or before running the schedule itself, we wish to check the availability of the data in the reporting server from where we are fetching the data. Anyone could help us to solve this issue?
Updated on 2012-10-26T05:07:02Z at 2012-10-26T05:07:02Z by SystemAdmin
zxning 2700002RFJ20 PostsACCEPTED ANSWER
Re: Infosphere Warehouse Design Studio Schedule facility2012-10-24T08:20:44Z in response to SystemAdminHi :
First you must be using schedule functions in Admin Console, not Design Studio, because there is no schedule facility in it.
About your request, there is not a simple method to check the source table. You can try the following solution:
1. write a stored procedure in the source database, which contains a sql like "select count(*) from XXX"
2. in the control flow, after the start operator, add a new StoredProcedure operator, and make it using the stored procedure you just created
3. the StoredProcedure operator can output the record count value to a variable, then add a VariableComparison operator to compare the value with 0, if the value > 0 then continue executing other operators in this flow, otherwise goto the End operator of this flow directly.
SystemAdmin 110000D4XK203 PostsACCEPTED ANSWER
Re: Infosphere Warehouse Design Studio Schedule facility2012-10-26T05:07:02Z in response to zxningThanks for the immediate reply. We are using the Admin Console for the schedule facility. In the reporting server, always data will be available. So SQL Count function would not be feasible. But we can check the connection to the server through the SQL Query and if it fails (find from the SQL Error code), we can change the schedule time. We will try it and update.