Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 9 Answers
- 30968 Views
- Cognizant, IBM, TCS, Virtusa, I also Faced
- E-Mail Answers
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 flow of project?
What are transforms and what is the differenece between routines and transforms?
What are the various kinds of containers available in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How many types of hash files are there?
What is the difference between orabulk and bcp stages?
What is the roundrobin collector?
What are the repository tables in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Differentiate between datastage and informatica?
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
What is the flow of loading data into fact & dimensional tables?
What is ibm datastage?
what is the use of surogate key in datastage
