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
Have you used Unstructured data?
What are the different options associated with dsjob command?
What are the components of datastage?
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
What are iconv and oconv?
How will you move hashed file from one location to another location?
Explain the importance of surrogate key in data warehousing?
Name the different sorting methods in datastage.
Explain entity, attribute and relationship in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
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
Describe stream connector?
How we can covert server job to a parallel job?
What are the different common services in datastage?