Skip to Content
0
Former Member
Jun 21, 2016 at 08:36 PM

Data Services ETL

42 Views

Hi

I have an ETL job that pulls data from a view and load into a target table. The ETL should only pull one day's data everytime it runs. For eg: It should pull T-1 data (sysdate -1) from the view and insert/update into the target tables in Hana. The view has a field called calendar id. How can i parameterize the date field in the ETL so when it only runs for the date that is provided? Can someone please help me?