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 |
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
table actions available in oracle connector?
where we use column generator stage in real time scenario?
Name the different types of Lookups in Datastage?
What all are the different way to run a job?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
Enlist various types of routines in datastage.
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
Define repository tables in datastage?