Skip to Content

Regarding Conditional Loading

Mar 14 at 02:42 AM


avatar image

Hi ,

I need some ideas on development of the below scenario.

I am extracting the data from one source system and loading into one target system.

In the source system table contains multiple entities data.

I have one table called Businessdate and it contains entity name, business date and state field. state field has the values open and closed for each entity based on data. All the tables should depend on this table for extract/load the data.

I need to extract the recent business data based on the state is closed.

For example If i have 3 entities and 2 of the entities only closed and still 1 is open then my schedule should load only closed entities not the open entities.

After some amount of the time again scheduler should run check remaining entities are closed or not . If closed those entities only run.

Please guide how to implement this type of logic.

Thanks & Regards,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Mar 19 at 11:21 AM

Is there any column which holds the date/time when this status is set to CLOSED.

10 |10000 characters needed characters left characters exceeded