How did you reconcile source with target?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / hemachandra
By using DSGetLinkInfo function we can trace out how many
records extracted from source and how many records loaded
into target
| Is This Answer Correct ? | 1 Yes | 0 No |
Display all files which have size more 3KB in given directory/folder.
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
What is the use of datastage director?
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
What are the important features of datastage?
how to do pergformence tuning in datastage?
What is APT_DUMP_SCORE?
Describe link sort?
How to generate surrogate key without using surrogate key stage?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?