Transformations execution

[AA3]

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

[former_member182470 · Accepted solution]

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

[esjewett · Accepted solution]

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

[esjewett]

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

[Former Member]

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.

BR

Adlin