Forum Stats

  • 3,839,782 Users
  • 2,262,536 Discussions
  • 7,901,055 Comments

Discussions

Variable in ODI

717374
717374 Member Posts: 14
edited Oct 19, 2009 12:32AM in Data Integrator
Hi All,

I am looking for option where i can do that validiity of a variable used as a sequencer @ interface level . I have done my testing @ package level and which works fine..

I am looking for option where i can do the testing of variable increment by 1 @ interface level....

FYI--Variable datatype is Numerical and action is historize , i have selected schema as well as mentioned query in the select query option.

if it is not possible is there any logic behind it or its just odi shortfall...

Thanks...

CG
Tagged:

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    Hi,

    In the Refreshing tab of the variable you could enter something like

    SELECT #NameOfVariable+1 FROM DUAL

    In a package first set or declare #NameOfVariable

    Then drag the variable onto the diagram again and set it to "Refresh Variable".

    This will increment your variable by 1.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 717374
    717374 Member Posts: 14
    Hi John,

    Thanks for the reply...even i have taken the same step what u hv mentioned...but i am looking for option @ interface level where i can avoid declaration/refresh steps in the package.. i.e. the variable can refreshed @ interface level...is it possible??

    CG
This discussion has been closed.