Interested to Buy Any Domain ? << Click Here >> for more details...
I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query.
- 2 Answers
- 9760 Views
- TCS, I also Faced
- E-Mail Answers
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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
what are the devoleper roles in real time? plz tell i am new to datastage....
Highlight the main features of datastage?
Why fact table is in normal form?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the types of views in datastage director?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
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?
What are the various kinds of containers available in datastage?
How to find value from a column in a dataset?
What are stage variables and constants?
Can you explain link buffering?
What is the difference between odbc and drs stage?
Differentiate between datastage and datastage tx?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
