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
Differentiate between Join, Merge and Lookup stage?
What is the purpose of pivot stage and types of containers in datastage
Difference between server jobs & parallel jobs?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to read multiple files using a single datastage job if files have the same metadata?
Differentiate between hash file and sequential file?
How do you import and export the datastage jobs?
What is quality stage?
How do u convert the columns to rows in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How many Key we can define in remove duplicate stage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the differences between datastage and informatica?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What can we do with datastage director?