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 Posts
Re: Infosphere Warehouse Design Studio Schedule facility2012-10-24T08:20:44ZThis is the accepted answer. This is the accepted answer.Hi :
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 Posts
Re: Infosphere Warehouse Design Studio Schedule facility2012-10-26T05:07:02ZThis is the accepted answer. This is the accepted answer.
- zxning 2700002RFJ