Skip to Content
0

How to read data from graphical calculation view with input parameters in SQL transform?

Nov 02, 2016 at 08:19 PM

38

avatar image

I have a graphical calculation view named "TestView" which uses two input parameters (

START_DATE_FINAL and END_DATE_FINAL)

In my data flow, I am using a SQL transform with the below select statement. It works if i hardcode the dates like this.

SELECT column1, column2 FROM "_SYS_BIC"."TestView"('PLACEHOLDER' = ('$$START_DATE_FINAL$$','2016-08-01','$$END_DATE_FINAL$$','2016-08-10'))

But i want to replace the hard coded values with 2 options.

Option 1:

START_DATE_FINAL - this should be passed as sysdate-1

END_DATE_FINAL - this should be passed as sysdate

Option 2:

Similarly i need another job or this same job that should run on every 1st day of month to pull previous months data . for eg: if the job runs on 11/1/2016 it should pull data from the view where start date = 10/1/2016 and end date = 10/31/2016.

START_DATE_FINAL - 10/1/2016

END_DATE_FINAL - 10/31/2016

Can someone please help me how i can do this? I am very new to data services so i would appreciate if the solution is explained in detail steps. Thanks in advance!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers