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
- 28071 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 use Array size in datastage
Define repository tables in datastage?
how many rows sorted in sort stage by default in server jobs
What are the areas of application?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the difference between informatica and datastage?
What are stage variables and constants?
EXPLAIN SCD
Where the datastage stored his repository?
Differentiate between hash file and sequential file?
Describe the main features of datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How do you remove duplicate values in datastage?
