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

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

Question Posted / kiran

2 Answers
9752 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

what is the use of surogate key in datastage

2307

Explain Quality stage?

1143

What are the difference types of stages?

1200

What is oci?

1296

What is aggtorec restructure operator?

1430

Explain usage analysis in datastage?

1155

What are the functionalities of link partitioner?

1012

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2052

What can we do with datastage director?

1232

What is the difference between validated and compiled in the datastage?

1277

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3746

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1382

How the ipc stage work?

1121

What is the difference between server job and parallel jobs?

1144

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2437