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
describe the Steps to confiure a Qlogic switch
Can you explain how could anyone drop the index before loading the data in target in datastage?
Does datastage support slowly changing dimensions ?
How many types of stage?
What are stage variables and constants?
Terminate Activity
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How do you generate sequence number in datastage?
Describe the main features of datastage?
What is the difference between an operational datastage and a data warehouse?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
explain about citrix scheduling tool in datastage
What is difference between symmetric multiprocessing and massive parallel processing?
Define Merge?
What is the difference between orabulk and bcp stages?