How did you reconcile source with target?

Answers were Sorted based on User's Feedback



How did you reconcile source with target?..

Answer / hemachandra

If you want to prepare Reconciliation report source with
target use the datastage internal function DSGetLinkInfo.
This function will show you how many records extracted from
source link and how many records loaded into target link.

Is This Answer Correct ?    6 Yes 0 No

How did you reconcile source with target?..

Answer / bi etl

selct count(*) from source table;

selct count(*) from target table;

Is This Answer Correct ?    1 Yes 0 No

How did you reconcile source with target?..

Answer / vaibhav gupta

For reconcilation of date You can use tool 'WinMerge'

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,


Define APT_CONFIG in Datastage?

0 Answers  


What are the different types of lookups in datastage?

0 Answers  


if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,


how does work server jobs?

1 Answers  






what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,


Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,


How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  


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

6 Answers   TCS,


Define data aggregation?

0 Answers  


how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,


How many jobs in ur project? Explain any complex job u have done in ur project?

1 Answers   IBM, TCS,


Categories