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

Can you highlight the main features of ibm infosphere information server?

0 Answers  


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


What is datastage?

0 Answers  


You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

1 Answers   TIAA CREF,


How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,


If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  


30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  


it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


what are the types of nodes

4 Answers   HCL, TCS,


If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,


i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me

0 Answers  


Categories