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
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
what is set mapping in datastage??
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
what is .dsx files
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
how to retrive the max(sal),deptno,empno in datastage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
what is the difference between == and eq in UNIX shell scripting?