Question Re: Transformations execution in Technology Q&A

Transformations execution

AA3 — Tue, 20 Nov 2012 02:14:32 GMT

For the Transformations in BI 7 onwards what is the order of execution of the routines mentioned below

1) Field routines (characteristic)

2) Master data lookup

3)Start Routine

4)End routine

which of the above get executed first

Re: Transformations execution

former_member182470 — Tue, 20 Nov 2012 04:14:43 GMT

HI,

Sequence:

1) Star Routine

2) Master Data Lookup

3) Field Routine

4) End Routine

If there are no transformation rules, we can use Expert Routine

Regards,

Suman

Re: Transformations execution

Former Member — Tue, 20 Nov 2012 07:05:17 GMT

Hi,

First, the code in start routine will be executed.

Then comes your master data look up followed by the field level routine.

At last, the end routine comes into picture.

When you debug the transformation, you will get to know in which order it is getting executed.

Also, you can check the generated program of a transfromation.

Adlin

Re: Transformations execution

esjewett — Mon, 26 Nov 2012 16:17:25 GMT

Hi folks,

Don't the master data lookups and field routines effectively run at the same time? The logic for each target field is executed field-by-field, so master data lookups and field routines can be intermixed. Please note, however, that the actual *lookup* of master data for the master data lookup rule type happens before the first record is processed.

Cheers,

Ethan

Re: Transformations execution

esjewett — Mon, 26 Nov 2012 16:20:38 GMT

Please don't use expert routines. They completely obscure meta-data about data flow and they provide an almost undetectable performance improvement over a standard transformation. The end result is that your BW system becomes unmaintainable very fast in exchange for a minuscule speedup. IMO, the only time expert routines are justified is when it is impossible or very inefficient to do the work in a standard transformation or a start/end routine. This is a very rare situation.

Regards,

Ethan