I am defining one varaible parameter date in job
parameters.I want use this variable date in where clause in
source query.
- 2 Answers
- 8567 Views
- TCS, I also Faced
- E-Mail Answers
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 |
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
how can find maximum salary by using Remove duplicate stage?
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
Display all files which have size more 3KB in given directory/folder.
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
Tell me the syntax of Configuration file?
What is the difference between datastage and datastage tx?
How complex jobs are implemented in datstage to improve performance?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
How to reverse the string using unix?
How many Key we can define in remove duplicate stage?
How to display all the duplicate records from the oracle Table?
Teradata 
