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
- 30709 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
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the difference between Datastage 7.5 and 7.0?
CHANGE CAPTURE
How and where you used hash file?
Have you used Unstructured data?
table actions available in oracle connector?
What is the flow of loading data into fact & dimensional tables?
how to implement scd2 in datastage 7.5 with lookup stage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is a quality stage in datastage tool?
What are routines in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Define APT_CONFIG in Datastage?
How a server job can be converted to a parallel job?
