Out of 4 mill records only 3 mill records are loaded to
target
and then job aborted. How to load only those 1 mill(not
loaded records) for next run.
This job is not sequential job, it is stand alone parallel
job.What are the possibilities available in datastage8.1?
Answer Posted / prasanna
Use already loaded records TGT as reference lookup,and use
lookup stage,with DROP option..and design the job.u ll get
req answer. refer
.
.
sour.......>lookup......>tgt
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Can you explain link buffering?
What are the types of containers and how to create them?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Describe routines in datastage? Enlist various types of routines.
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 ?
What are the differences between datastage and informatica?
Can you explain repository tables in datastage?
What is the process of killing a job in datastage?
Name the command line functions to import and export the DS jobs?
how to export or import the jobs in .ISX file
What is the precedence of stage variables,derivations, and constraints?
To see hidden files in LINIX?
What is difference between symmetric multiprocessing and massive parallel processing?
Difference between sequential file and data set?
Can you explain engine tier in information server?