0

Using Session Variables in Load Filter syntax

Can we use session variables in Load Filter (specified in table details in schema) ? If yes, what is the syntax?

I have created a session variable GLOBAL_CURR_CD_Sample. I am planning to add a load filter to GL_DAILY_RATES  table with the following condition.

TO_CURRENCY=$GLOBAL_CURR_CD_Sample

This gives me the following error.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Sorry this is not supported.   Please hard code the filter for now.  We hope to support Session variables in the Extract sqls and load filters in the future.

    Reply Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 1Replies
  • 20Views
  • 2 Following