I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query.
Answer Posted / ram
As Kiran said you call in sorce query..
Define pDate as jobparameter..
In Query ..
Ex:
Select loc,div from xxx where dim_t = '#pDate'
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How can one find bugs in job sequence?
What are the different types of lookups in datastage?
Can you explain repository tables in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How do you remove duplicate values in datastage?
What is data partitioning?
what is the use of materialized view?
What is the use of hoursfromtime() function in transformer stage in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is datastage engine?
What are the different layers in the information server architecture?
Explain entity, attribute and relationship in datastage?
What are some different alternative commands associated with "dsjob"?
How do you generate sequence number in datastage?