This discussion is archived
1 Reply Latest reply: Jan 10, 2013 12:54 AM by jorsodom RSS

Behaviour of global objects in ODI

928200 Newbie
Currently Being Moderated
Hi Friends,

In ODI
Designer->Global objects->Globla User Functions->

Here i have some folders like
Conversion Operation ->TO_CHAR_FORMAT function
Substitution ->GET_SCEN_NAME - For this in implementation ODI related stuff to get the scenario name which etl now it is running.

etc like that


My problem is sometimes i am not bale get the value of GET_SCEN_NAME,TO_CHAR_FORMAT

like WHERE     PACKAGE_NAME='GET_SCEN_NAME()'
some time it works fine,

why it is not getting the value of that functions.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points