BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Regarding Conditional Loading

Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
Principal Member
Principal Member

Joined: 30 Apr 2009
Posts: 445
Location: Bangalore

PostPosted: Tue Mar 13, 2018 9:42 pm 
Post subject: Regarding Conditional Loading

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,

Back to top
Senior Member
Senior Member

Joined: 08 Jan 2014
Posts: 74

PostPosted: Fri May 18, 2018 2:41 am 
Post subject: Re: Regarding Conditional Loading

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.
Thanks & Regards,
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0294 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0258)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo