How many Key we can define in remove duplicate stage?
No Answer is Posted For this Question
Be the First to Post Answer
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
whom do you report?
What are the job parameters?
what is the exact difference between dataset and fileset in datastage?
Define data aggregation?
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
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how can you generate sequence number using only the sequential file stage?
Enlist various types of routines in datastage.
CHANGE CAPTURE
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
how can we create rank using datastage?what is the meaning of rank?