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 |
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
How do you start developing a datastage project?
Why do we use exception activity in Datastage?
What are the areas of application?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A
how to write server Routine coding?
1)Source file contains one record, I want 100 records in target file.
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
how to find no.of records in sequntial file itself?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?