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 |
Can you explain link buffering?
What is usage analysis in datastage?
How to create a doccument in datastage?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
can we use sequential file as a lookup
What is PX?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
in oracle target stage when we use load option and when we use upsert option?
What a datastage macro?
DataStage Scenario based Interview Questions
What are the stages in datastage?