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

how to add a new records into source?

2005

what is flow of project?

2007

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2381

What are sequencers?

1124

What is the difference between Datastage 7.5 and 7.0?

1105

What is the use of hoursfromtime() function in transformer stage in datastage?

1070

What is the purpose of interprocessor stage in server jobs?

2233

What are the different type of jobs in datastage?

1046

What is ibm datastage flow designer?

1156

What are orabulk and bcp stages?

1132

On which Dimension Table you implemented SCD Type in your Project

2058

client know skid info?

2088

How to find value from a column in a dataset?

2211

How to RD using transformer?

1431

how can we create rank using datastage?what is the meaning of rank?

8797