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
- 9788 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 |
Is there any possibility to generate alphanumeric surrogate key?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between informatica and datastage?
how to find no.of records in sequntial file itself?
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
What modeling tool do you use?
Can you explain kafka connector?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
1)Source file contains one record, I want 100 records in target file.
how to export or import the jobs in .ISX file
What is the purpose of pivot stage?
Teradata 
