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
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 |
Answer / kiran
yes u can define date parameter as variable and call in
source query.
Is This Answer Correct ? | 5 Yes | 1 No |
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
what is a message handler
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What is the importance of the exception activity in datastage?
how can we create a Sorrogate key in transformer stage? I want it in parallel mode
CHANGE CAPTURE
Differentiate between Join, Merge and Lookup stage?
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
Why we use parameters instead of hard code in datastage.
How to find value from a column in a dataset?
Thanks to all people who are posting their comments...
Can you explain players in datastage?