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

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

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2275


What is the command line function to import and export the ds jobs?

681


what is the use of materialized view?

964


what is ds administrator used for?

722


Explain the situation where you have applied SCD in your project?

1562






1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3503


What is job control?

624


What is the purpose of pivot stage?

608


How do you import and export the datastage jobs?

735


What are datastage sequences?

671


What are the some differences between 7.x and 8.x version of datastage?

742


in oracle target stage when we use load option and when we use upsert option?

1753


What is "fatal error/rdbms code 3996" error?

663


options available in sequence job to run,validate?

840


root tree will find which is server job and which is parallel job?

1455