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
What are the functionalities of link partitioner?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Difference between sequential file and data set?
what is the Difference Between Datastage Server Edition and Parallel Edition?
HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?
What is the difference between operational data stage (ods) and data warehouse?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is data mapping
how can we extract data with out having any common column