How did you reconcile source with target?
- 2 Answers
- 11012 Views
- HP, I also Faced
- E-Mail Answers
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 |
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
What is the difference between SQl Loader and OCI in datastage?
Which type of joins Merge stage can support?
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?
Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.
In merge stage can we update the values?
Tell me the syntax of Configuration file?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
Can aggregator and transformer stages use to sort the data? How ?
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
Teradata 
