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: Upcoming Events: PGHBOUG: Oct 19.

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
Ramana
Principal Member
Principal Member



Joined: 30 Apr 2009
ASUG Icon
Posts: 445
Location: Bangalore


flag
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,

Ramana.
Back to top
niranjan479
Senior Member
Senior Member



Joined: 08 Jan 2014
ASUG Icon
Posts: 74
Location: HYDERABAD


flag
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,
Niranjan
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.0026 Parse 0.0009 Other 0.0259)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo