I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kiran
yes u can define date parameter as variable and call in
source query.
Is This Answer Correct ? | 5 Yes | 1 No |
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
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?
What is datastage?
What are the functionalities of link collector?
Hi This is Vijay, How can your remove the duplicates in sequential File?
15 Answers HCL, Scope International,
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
What is staging variable?
how CAN we remove duplicates in dataset?
what is the difference between the active datawarehouse and datawarehouse
what is the function in Transformer stage can act as Rank function in Oracle
How can you write parallel routines in datastage PX?