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...

  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 / ram

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Terminate Activity

1231

Which algorithm you used for your hashfile?

1120

What is data partitioning?

1135

What is job control?

1034

How do you remove duplicate values in datastage?

1092

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3129

What is meta stage?

1131

Define Data Stage?

1040

What are the types of views in datastage director?

1720

On which Dimension Table you implemented SCD Type in your Project

1969

What is difference between symmetric multiprocessing and massive parallel processing?

1081

Describe the main features of datastage?

1035

What is staging variable?

1026

What are iconv and oconv?

1180

how to sort two columns in single job in datastage.

2840