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

Have you used Unstructured data?

826


What are the different options associated with dsjob command?

930


What are the components of datastage?

643


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

543


What are iconv and oconv?

768






How will you move hashed file from one location to another location?

1651


Explain the importance of surrogate key in data warehousing?

706


Name the different sorting methods in datastage.

607


Explain entity, attribute and relationship in datastage?

629


Have you have ever worked in unix environment and why it is useful in datastage?

643


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2422


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1461


Describe stream connector?

824


How we can covert server job to a parallel job?

591


What are the different common services in datastage?

696