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
- 9792 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 |
What is the difference between SQl Loader and OCI in datastage?
what is advantages of snowflake when it is used?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
How and where you used hash file?
Difference in the implementation of lookup and join stages,in joining two tables?
What are datastage sequences?
How do you import and export the datastage jobs?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
How did you reconcile source with target?
whats difference between ls -ltr and ls -lrt?
Teradata 
