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 |
how can i abort the job if i get more than 100 errors in job log?
What are the different layers in the information server architecture?
How to move data set from one server to other?what are the steps to follow to do this?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
i have input like this Column 1 ,column 2 3,a 4,b 5.c i want output aaa bbbb ccccc Ple help any one?
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
on how many columns we can perform aggregation in the aggregator stage?
What r the existing server jobs in parallalism?
Can aggregator and transformer stages use to sort the data? How ?
which is the most complex job in your career? Please tell me answer?
How many jobs in ur project? Explain any complex job u have done in ur project?
what is the custome stage in datastage? how can we impliment that one? plz tell me