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 |
wt is the difference between swith and filter stage
Which commands are used to import and export the datastage jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
on how many columns we can perform aggregation in the Aggregator stage?
what is the use of skid in reporting?
What are the benefits of datastage?
How to create a doccument in datastage?
what are fact tables and dimension tables? give example assuming one table.
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What is the difference between datastage and informatica?
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