End routine for multiple Transformation

[former_member217394]

Hi

Transformation of 6 WO-DSOs to 1 Std.-DSO and End routine is define in 1st Transformation which pull data from other 5 DSOs. How many DTPs should be created to transfer 6DSO data into 1 DSO, and which DTP should run first the one which have END ROUTINE or any DTP can run first?

Thanks

[Former Member · Accepted solution]

I had a similar issue. I had to load data from 2 DSO(with header and item data) into 1 final DSO. I wrote the END ROUTINE for one DSO by which I fetched data from 2 Other DSOs. I created the DTP only for the DSO which had the END ROUTINE written in. And I ran the DTP and successfully loaded data.

Hope you find this information useful.

And to answer your question. you should only create DTP for one transformation you are writing END routine in.

[former_member217394 · Accepted solution]

Thanks Vishnu, I am doing as your suggestion. Will hope for better result.

[sander_vanwilligen]

Hi,

If I understood you correctly, there is only one Transformation between DSO 1 and the Target DSO. The other 5 DSOs are read in the End Routine of the Transformation (i.e. 5 times a DSO read / lookup). In this case you only need one DTP from DSO 1 to Target DSO.

Best regards,

Sander

[former_member217394]

Hi Sander,

Thanks for your nice answer.

Please elaborate, This is my case please clarify me

It is clarify that only 1DTP is required for DSO1 to TargetDSO which contained END ROUTINE, but is remaining 5 DSOs required Transformation or not? because every DSO are transferring some fields basis on DSO1!

[Loed]

Hi,

If you are only going to use the 5 DSOs as "lookup tables" for your DSO1, then you only need 1 DTP, as Sander said..

However, if you also need to transfer some data from those 5 DSOs, then you need a total 6 DTPs (1 for each DSO) going to TARGET DSO..

About the which DTP will run first depends on your design..But given on the details you have mentioned here, any of the 6 DTPs can run first since they don't depend on each other..

Regards,

Loed

[former_member217394]

Hi Leod,

Thanks.

Is it possible that we can take data from Multiple DataSources to single InfoSource and apply LOOKUP END ROUTINE in InfoSource to DSO transformation instead of loading data into multiple DSOs then to target DSO Using LOOKUP END ROUTINE?

Thanks

[Loed]

Hi,

Yes that's also possible, PROVIDED that all your datasources have the same fields..

However, I will not recommend it since infosource (I think) cannot handle duplicate data (which DSO can provide)..So I will stick to DATASOURCE to SEVERAL DSOs then to TARGET DSO..

Some references:

http://help.sap.com/saphelp_nw70/helpdata/en/7e/001342743eda2ce10000000a1550b0/content.htm

InfoSource - Modeling - SAP Library

use of infosource in SAP BI 7.0 | SCN

Regards,

Loed

[anindya_bose]

Hi

Number of transformation =  number of DTPs .  I believe you have 5 transformations.

Sequence could not be confirmed without seeing actual scenario. You might try different options, but make sure one transformation should not overwrite data from previous one unintentionally.

Cheers

Anindya