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


Please Help Members By Posting Answers For Below Questions

describe the Steps to confiure a Qlogic switch

1939


Can you explain how could anyone drop the index before loading the data in target in datastage?

896


Does datastage support slowly changing dimensions ?

661


How many types of stage?

678


What are stage variables and constants?

703






Terminate Activity

841


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1930


How do you generate sequence number in datastage?

625


Describe the main features of datastage?

660


What is the difference between an operational datastage and a data warehouse?

637


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3271


explain about citrix scheduling tool in datastage

1812


What is difference between symmetric multiprocessing and massive parallel processing?

655


Define Merge?

879


What is the difference between orabulk and bcp stages?

576