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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.