I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..
Answer Posted / shar
ok now we have an reject job with stages like
seq--tx--dataset1 lets say job1
now take job2 (job) dependency from job1 to job2) in that
get the data from seq use tx as input 1 (primary) and dataset2 as secondary (ref) in which we use path of dataset1 file this as second input. now connect these inputs to lookup stage and reject the unmatched records connect the reject link to dataset3 in which file name should be same as dataset1 with update policy = append.
thats it dude.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between datastage and informatica?
What are the difference types of stages?
What are the processing stages?
What are the different layers in the information server architecture?
What is oci?
Can you highlight the main features of ibm infosphere information server?
what is the use of surogate key in datastage
Differentiate between datastage and informatica?
What are the differences between datastage and informatica?
CHANGE CAPTURE
What are the areas of application?
Explain datastage architecture?
Differentiate between data file and descriptor file?
What are the components of ascential data stage?
What is use Array size in datastage