1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / suneetha

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

What is apt_config in datastage?

0 Answers  

Pls tell me what is troubleshooting in datastage view?

1 Answers  

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

what is meta data? Explain? Where it is used?

9 Answers  




how to call sequential generator in datastage?

1 Answers   IBM,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

What is the differentiate between data file and descriptor file?

0 Answers  

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

how can we create tables in datastage?

1 Answers  

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

For more Data Stage Interview Questions Click Here
Categories