i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE
7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD
MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD
MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME
HOW CAN I DO THAT.
THANKS
No Answer is Posted For this Question
Be the First to Post Answer
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
How many types of stage?
on how many columns we can perform aggregation in the aggregator stage?
What is the function in Transformer stage can act as Rank Function in oracle
What can we do with datastage director?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Give an idea of system variables.
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
What is a folder? Difference types of stages?
i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?