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