Regarding Conditional Loading

dataservices job design
1

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.

Ramana :india: (BOB member since 2009-04-30)

2

Have a script at the start of the flow to get the tables/entities that has status closed… Design the data flows for each entity you want to load. Have a conditional for each data flow and initialize the entity name that will be loaded in a variable. Check the condition against the tables that you returned in the first script and run the dataflow only if the tables matches.

niranjan479 :india: (BOB member since 2014-01-08)