How to Pass dataset field value to job parameter/parameter s
Posted: Tue Sep 23, 2008 10:14 am
I have a job1 that retrives a control parameter (region name) from a table (teradata) and writes it to a dataset.
My job2 has to read the region name from the dataset created in the job1 and pass it to the job2 as parameter in SQL selection criteria in teradata connector stage as parameter.
Example:
Job1 output dataset: Region name = USA.
Job2 teradata connector stage has SQL select * from Customer_sales where Region = '#Region name#'
here in the job2 the 'region name' parameter to be passed from the job1 dataset value 'USA'.
Can anyone please help me on how to implement this in information server parallel job?
Thank you for the help.
My job2 has to read the region name from the dataset created in the job1 and pass it to the job2 as parameter in SQL selection criteria in teradata connector stage as parameter.
Example:
Job1 output dataset: Region name = USA.
Job2 teradata connector stage has SQL select * from Customer_sales where Region = '#Region name#'
here in the job2 the 'region name' parameter to be passed from the job1 dataset value 'USA'.
Can anyone please help me on how to implement this in information server parallel job?
Thank you for the help.