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

What all the types of jobs you developed?

1140

How many areas for files does datastage have?

1109

What is the difference between operational data stage (ods) and data warehouse?

1202

What is apt_config in datastage?

1100

Define ds designer?

1236

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2154

What are the repository tables in datastage?

1277

How to RD using transformer?

1379

What is the difference between datastage and datastage tx?

1031

Name the different sorting methods in datastage.

1007

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1169

How can one find bugs in job sequence?

1347

Explain Quality stage?

1122

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2471

How and where you used hash file?

1131