Dynamic parameter passing to OCI Stage

[nchincholikar]

Hi everybody,

We have 2 hash files.And 1 Oracle Stage.

I want to pass Hash1 Arr_Id and Hash2 Bill_date to Oracle Oci stage as a dynamic parameter.

So query will be like below

Select sum(Tram_amt)
from t1
where arr_id=&Hash1_Arr_id
and dt=&Hash2_Bill_date

Thanks & Regards,
Narendra

[Sainath.Srinivasan]

Best will be to split them as 2 jobs. First obtaining the values and the next passing to OCI as params. You may need a third to cover both.

[ray.wurlod]

So the query will look like:

Code: Select all

Select sum(Tram_amt) 
from t1 
where arr_id=#Hash1_Arr_id# 
and dt='#Hash2_Bill_date#' 

You can use job parameter references even in generated SQL. You can also use aggregate functions such as SUM (in Derivation in the Columns grid) in generated SQL.