Regarding Conditional Loading

[venkataramana_paidi]

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,

Ramana.

[former_member208402]

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