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
how can we create rank using datastage?what is the meaning of rank?
What is job control?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the types of containers in datastage?
What are the difference types of stages?
What is the use of datastage director?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is difference between symmetric multiprocessing and massive parallel processing?
how do u catch bad rows from OCI stage? And what CLI stands for?
how to sort two columns in single job in datastage.
Where do the datastage jobs get stored?
What is use Array size in datastage
How you Implemented SCD Type 1 & Type 2 in your project?
Why do we use exception activity in Datastage?
EXPLAIN SCD