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



I am defining one varaible parameter date in job parameters.I want use this variable date in where..

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

I am defining one varaible parameter date in job parameters.I want use this variable date in where..

Answer / kiran

yes u can define date parameter as variable and call in
source query.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Data Stage Interview Questions

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

7 Answers  


How do you start developing a datastage project?

0 Answers  


Why do we use exception activity in Datastage?

0 Answers  


What are the areas of application?

0 Answers  


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

2 Answers  


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

3 Answers   IBM,


how to write server Routine coding?

0 Answers   Eric,


1)Source file contains one record, I want 100 records in target file.

3 Answers  


what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,


deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,


how to find no.of records in sequntial file itself?

4 Answers  


IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


Categories