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

Answer Posted / kiran

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

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

why do u need the IOS upgradation in a FC switch

2233

Why do we use link partitioner and link collector in datastage?

1083

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

1232

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2412

what is ds administrator used for?

1120

Differentiate between data file and descriptor file?

997

What is the roundrobin collector?

1049

Differentiate between hash file and sequential file?

1010

What are some different alternative commands associated with "dsjob"?

1090

What are the job parameters?

1168

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

1342

Explain connectivity between datastage with datasources?

944

What is the difference between server job and parallel jobs?

1100

how do u catch bad rows from OCI stage? And what CLI stands for?

2757

How many Key we can define in remove duplicate stage?

1323