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
Paul Johnson —
You can do this two different ways.
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.
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.