Data Services - Data Flows Replication

[Former Member]

I'm building 60 validation rules in SAP BODS. Each validation rule is in the form of the following data flow :

so in total I have 60 data flows.

My problem is that I have to do these 60 validation rules for 10 affiliates/companies using the same source tables but I want to store the failed records in separate tables for each company. The way I filter based on company is by changing a value for one field in the "where" clause in the Query transform. (e.g. Where company = 'xxxx') where 'xxxx' is different for each company. ==> total = 600 data flows and each one is a job ==> 600 jobs.

I want to create 60 jobs under a project and then copy/paste 10 times, but this feature isn't available in BODS. What is the easiest way to replicate the 60 jobs 10 times ?

[Former Member]

Hi Abdullah,

Try this out and see.

Firstly,  Instead of using 60 data flows for 60 rules. Implement all your validation rules in One data flow.(I am Assuming these rules are common for all the 10 companies).

Now you have 10 companies to execute.

1. You can now replicate this Data Flow with 60 validations, Go to Local Object Library,right click on your validations data flow and click on "Replicate". It will create a copy of your data flow just below the original Data Flow. Rename the copy Data Flow to one of your Company name. Repeat this for all the 10 companies data you want to execute.

2. Now you have 10 Data Flows, one for each company and each of those data flows will have 60 validations.

3. In each of these Data Flows change the out put table names. This is an important step. If not not done will create replications of same tables. You can give your out put table names as eg: Company1_Pass,Company1_Fail. Repeat this for all the 10 Data flows.

Now you can have all the your validations done for 10 companies with 10 DF's and you can capture failed records as well..

Try this out.

Regards,

Dhruva.

[former_member300391]

And to elaborate on Dhruva's solution..get or create a source that lists the 10 companies..and use a script and a while loop to populate a variable for the company variable..and use the variable in your query.  Now you only need one DF.