How did you reconcile source with target?

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


Please Help Members By Posting Answers For Below Questions

How to reverse the string using SQL?

898


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2037


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

1661


What is the difference between datastage and informatica?

616


What is the sortmerge collector?

670






Can you explain kafka connector?

781


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

369


What are the enhancements made in datastage 7.5 compare with 7.0?

713


Have you have ever worked in unix environment and why it is useful in datastage?

657


What is data partitioning?

747


What is aggtorec restructure operator?

731


What is a datastage job?

625


What are datastage sequences?

676


Can you explain tagbatch restructure operator?

707


client know skid info?

1638