Skip to Content
0
Former Member
Jan 10, 2011 at 12:20 PM

Difference 1st and 2nd global declaration in the start routine of a transfo

1233 Views

Hi Folkds,

What is the difference between first and second global declaration in the start routine of a transformation?

First: $$ begin of global - insert your declaration only below this line -

Second: $$ begin of 2nd part global - insert your code only below this line *

I browse a lot of forum post but got no clear definition. Bellow definition from one post seemd to be the most approriated, but as there where several other onces I wanted to re-check if somebody can confirm bellow:

-


There are two places where you can make a global declaration in a Start or End Routine.

1. $$ begin of global - insert your declaration only below this line -

... "insert your code here

*" In this part your global declarations values will only be retained for the 1st packet. For e.g. if here you are reading any date range from a Ztable, then it will applt only for the first data packet

.*2. $$ begin of 2nd part global - insert your code only below this line *

... "insert your code here

$$ end of 2nd part global - insert your code only before this line *

" You need to declare here in a scenario where data volume is large and you need to retain the values across the whole data set comprising of multiple packets. (As e.g I cited above)

-


Some difference I noted is that 1st part never acceptes an include. But 2nd part does.

Thanks for all replies in advance,

Axel