Answer Posted / ramya
1. Use Show Performance Statitics option, while
running your job.
This will give you records read from source, written to
output link and written to Reject link.
2. If you want job statistics in a file, Call the
DSendJobReport with the argument 2;directorypath in
the "After routine" of the job for which the statistics are
required.
This creates the job log in text format in the
directorypath specified.
This will give you number of records read, written and
rejected. You could write a shell script to format it if
required.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
How do you generate sequence number in datastage?
What are the functionalities of link collector?
What is the difference between datastage and datastage tx?
What is a merge in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How can you write parallel routines in datastage PX?
what are the errors,warnings in datastage
Can you explain kafka connector?
How the ipc stage work?
how to write server Routine coding?
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
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the process of killing a job in datastage?