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
Why fact table is in normal form?
what is the use of materialized view?
What are the functionalities of link collector?
What are the types of hashed files in data stage
How do y read Sequential file from job control?
Define project in datastage?
What is datastage?
Can you define merge?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Differentiate between data file and descriptor file?
What are system variables and sequencers in datastage
Define repository tables in datastage?
Lookup constraints