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

Which commands are used to import and export the datastage jobs?

992


How do you generate sequence number in datastage?

635


What are the functionalities of link collector?

639


What is the difference between datastage and datastage tx?

606


What is a merge in datastage?

784






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

1819


How can you write parallel routines in datastage PX?

632


what are the errors,warnings in datastage

2173


Can you explain kafka connector?

785


How the ipc stage work?

684


how to write server Routine coding?

1675


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

374


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

547


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

1665


What is the process of killing a job in datastage?

597