Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Passing variable

how will pass the last_udpate_date to the matillion as a variable to fetch on the delta data which are updated in oracle ERP. how will i do it ?

1 Community Answers

Matillion Agent  

Paul Johnson —

Hi Preethish,
You can do this two different ways.

  1. Create a view on the table that contains the last_update_date which is a MAX of that column, so the view is one row one column. Then in your job create a job variable to store this value and use a table iterator to map the value in a view to the job variable. Then you can use it in a filter to capture the delta.
  2. You can use a python component to create a jython cursor object which similarly gets the MAX value from that column and stores it in a job variable. Again you can then use this in a filter on your data stager component.

Regards.Paul

Post Your Community Answer

To add an answer please login