Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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

How to implement complex jobs in data stage?

0 Answers  


how to handle null values in sequential file?

1 Answers   HCL,


how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,


count number of deptno in a emp table?

2 Answers   IBM,


1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  


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

0 Answers  


What are the processing stages?

0 Answers  


What is the precedence of stage variables,derivations, and constraints?

0 Answers  


Explain connectivity between datastage with datasources?

0 Answers  


source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers   Patni,


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


DataStage Scenario based Interview Questions

1 Answers  


Categories