How did you reconcile source with target?

Answers were Sorted based on User's Feedback



How did you reconcile source with target?..

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

How did you reconcile source with target?..

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

Post New Answer

More Data Stage Interview Questions

Does datastage support slowly changing dimensions ?

0 Answers  


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

0 Answers  


What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,


how can we create a Sorrogate key in transformer stage? I want it in parallel mode

2 Answers   Syntel,


What is the difference between lookup and sparse lookup?

1 Answers  






diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,


How To find the location of APT_confid file

2 Answers   CTS,


how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,


Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,


what is materialized view used datastage?

1 Answers   HSBC,


WHAT are unix quentios in datastage

2 Answers   TCS,


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


Categories