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.


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.

Like Follow
  • Status Answered
  • 9 mths agoLast active
  • 1Replies
  • 37Views
  • 2 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!