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

How you Implemented SCD Type 1 & Type 2 in your project?

3705


What is the project in datastage?

681


Why do you need stage variables?

680


Whats difference betweeen operational data stage (ods) and data warehouse?

679


What are the types of containers?

706






What is the difference between in process and inter process?

686


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2331


What is apt_config in datastage?

715


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1758


Define orabulk and bcp stages?

702


EXPLAIN SCD

979


What is staging variable?

637


What are stage variables and constants?

720


What is the purpose of pivot stage and types of containers in datastage

623


Describe the architecture of datastage?

582